--- 创建目录,这是必须的
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\'\)\"
Oracle Data Dump 导出 --- 很快,很强大
最新推荐文章于 2021-04-13 03:55:56 发布