Oracle Data Dump 导出 --- 很快,很强大

--- 创建目录,这是必须的
CREATE DIRECTORY datadir1 AS '/opt/oracle/wkdir';

--- 不过还得需要这个目录的真实存在,
SQL> ! mkdir -p /opt/oracle/wkdir

--- 授权

GRANT READ,WRITE ON DIRECTORY datadir1 TO db_user;

--- 导出

expdp db_user/db_passwd@dbName SCHEMAS=db_user  parallel=4 DUMPFILE=datadir1:schema1%U.dmp LOGFILE=datadir1:expschema.log

--- 导入

impdp db_user/db_passwd@dbName SCHEMAS=db_user  parallel=4 DUMPFILE=datadir1:schema1%U.dmp EXCLUDE=constraint, ref_constraint, index,materialized_view TABLE_EXISTS_ACTION=replace logfile=datadir1:impschema.log

--- 导出时指定不导出某表
expdp clearspace/XSJpa4TdQn2RJBL@bocc SCHEMAS=clearspace DUMPFILE=datadir1:schema1%U.dmp  parallel=4  LOGFILE=datadir1:expschema.log  EXCLUDE=TABLE:\"IN\(\'table1\',\'table2\'\)\"