expdp/impdp 备份/还原数据库
--创建目录
create or replace directory UTL_FILE_DIR as 'C:\Users\Administrator\Desktop';
--将目录授权给要导出的用户test
grant read, write on directory UTL_FILE_DIR to test;
--导出全数据库
expdp 'userid="/ as sysdba"' full=y
-----导出指定用户test
expdp test/test@127.0.0.1/oracle schemas=test dumpfile=test.dmp logfile=exp_test.log directory =UTL_FILE_DIR
-------文件太大,内存太小,可以用如下语句,压缩一下
expdp test/test@127.0.0.1/oracle directory=UTL_FILE_DIR dumpfile=test.dmp COMPRESSION=all logfile=exp_test.log
--导出指定表(指定行数)
expdp test/test@127.0.0.1/oracle directory=UTL_FILE_DIR dumpfile=test.dmp tables=TB_test query=\"where rownum\<5000\"
--impdp 导入数据库
create or replace directory UTL_FILE_DIR as '/u01/bak_data';
grant read, write on directory UTL_FILE_DIR to test;
----imp导入
impdp test/test@127.0.0.1/oracle schemaS=test dumpfile=test.dmp logfile=test.log directory =UTL_FILE_DIR ignore=y
---不同用户之间的导入,由test导入test1
impdp test1/test1@127.0.0.1/oracle dumpfile=test.dmp directory =UTL_FILE_DIR remap_schema=test:test1 ignore=y