Top Posts Tagged with #dbms_metadata

Drop table cascade and reimport

Happy new year :)

Today I had to import a subset of a database and the challenge was to restore a parent table without restoring its children. It took me some minutes to write the code, but it would have taken days to restore the whole database.

CREATE TABLE t1( c1 NUMBER CONSTRAINT t1_pk PRIMARY KEY); INSERT INTO t1 (c1) VALUES (1); CREATE TABLE t2( c1 NUMBER CONSTRAINT t2_t1_fk REFERENCES t1,

View On WordPress

#datapump #DBMS_METADATA

•18+ Adults Only

Watch Anya Live on Cam

Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.

✓ Live Streaming✓ Interactive Chat✓ Private Shows✓ HD Quality✓ Free Actions

Free to watch • No registration required • HD streaming