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
