DataPumpでメタデータ（DDL）のみエクスポートする

書式

$ expdp <username>/<password> directory=<directory object> content=metadata_only schemas=<schema name> dumpfile=<dump file name> LOGFILE=<log file name>

実行例

$ expdp system/manager directory=pump_dir content=metadata_only schemas=scott,hr dumpfile=ddl_scott_hr.dmp LOGFILE=exp_ddl_scott_hr.log

参考

• https://docs.oracle.com/database/121/SUTIL/GUID-F7994C75-CC86-4A5D-AA9A-361A94FD9C03.htm#SUTIL838
• https://docs.oracle.com/database/121/SUTIL/GUID-8B512637-E259-4F20-B7C9-DCD0BB501D09.htm#SUTIL864