1. Login to Oracle db
expdp "'"/ as sysdba"'" schemas=schema_name1,schema_name2 dumpfile=dumpfile.dmp content=METADATA_ONLY LOGFILE=expdp.log
2. Use sqlfile option with impdp
impdp "'"/ as sysdba"'" dumpfile=dumpfile.dmp sqlfile=ddl.sql
3. The output ddl.sql will contain the schema DDL of the mentioned schemas.
No comments:
Post a Comment