Skip to content

Laurent Schneider

Oracle Certified Master

Tag: 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… Continue reading Drop table cascade and reimport

Published January 19, 2016
Categorized as dba Tagged datapump, 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

Published August 20, 2014
Categorized as dba, sqlplus Tagged DBMS_METADATA
Laurent Schneider
Proudly powered by WordPress.