只导出表结构的SQL语句

导出

DIRECTORY=DATA_DIR

LOGFILE=SQL_201704120914.log

DUMPFILE=SQL_201704120914.dmp

SCHEMAS='XXX',,'XXX'

CONTENT=METADATA_ONLY

 expdp \'/ as sysdba\' parfile=google.par 

 

导入产生SQL，并不会实际执行导入过程

DIRECTORY=DATA_PUMP_DIR

LOGFILE=imp_SQL_201704120914.log

DUMPFILE=SQL_201704120914.dmp

INCLUDE=TABLE

SQLFILE=jdcw.sql

 impdp \'/ as sysdba\' parfile=google.par 

转载于:https://www.cnblogs.com/dfzzqq/p/6697718.html