Using datapump to extract DDL

Using datapump to extract DDL

To export

expdp system/******** directory=data_pump_dir schemas=opera dumpfile=opera.dmp include=package

To import

impdp system/******** directory=data_pump_dir sqlfile=sqlfile.log include=package:>'RES'

Eg :

• PACKAGE:"LIKE '%API'" -- end with API
• package:>'RES' -- start with RES
• include=table,view,procedure - you can export procedure, function, package, indexes
• EXCLUDE=SCHEMA:"IN ('OUTLN','SYSTEM') - exclude schemas