#dbms_metadata

[laurentschneider]

Drop table cascade and reimport

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