只导出表结构的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 

posted @ 2017-04-12 09:48  My Data Support  阅读(2974)  评论(0)  编辑  收藏  举报