Oracle expdp/impdp with DDL only

expdp schema/password@localhost:port/service dumpfile=DATA_PUMP_DIR:db_metadata.dmp logfile=DATA_PUMP_DIR:db_expdp.log content=metadata_only

Exclude storage for tables and segment attributes for tables:

impdp schema/password@localhost:port/service dumpfile=DATA_PUMP_DIR:DB_METADATA.dmp logfile=DATA_PUMP_DIR:log.log sqlfile=DATA_PUMP_DIR:sql.ddl transform=SEGMENT_ATTRIBUTES:n:table,STORAGE:N:table

Exclude storage and segment attributes for all objects:

impdp IPH/IPH@localhost:1522/incentage dumpfile=DATA_PUMP_DIR:DB_METADATA.dmp logfile=DATA_PUMP_DIR:log.log sqlfile=DATA_PUMP_DIR:sql.ddl transform=SEGMENT_ATTRIBUTES:n,STORAGE:N

Leave a Reply