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… Continue reading Drop table cascade and reimport
Tag: DBMS_METADATA
DBMS_METADATA.GET_DDL in sqlplus
Some settings matter when using dbms_metadata. define large clobs set long 1000000 large long columns set longchunksize 32000 long lines set linesize 32000 no trailing spaces set trimspool on no header set heading off no page size set pages 0 no page feed (^L) set newpage none no start of page set embedded on no… Continue reading DBMS_METADATA.GET_DDL in sqlplus