一般来说，expdp备份的步骤如下：
注：数据泵只能在oracle服务端使用，此处可以备份多个加条件的表
1、创建DIRECTORY
create directory etl_dump as 'D:\oracle\dir_dp';
2、授权
Grant read,write on directory etl_dump to etl_qy;
3、备份
expdp scott/tiger@orcl directory=ETLDUMP dumpfile=aaq1.dmp tables=emp,dept QUERY = 'EMP:"where deptno =20"','DEPT:"where deptno <=20 and deptno >=10"'
4、恢复
impdp liuyy_001/liuyy_001@orcl dumpfile = aaq1.dmp tables = emp,dept directory=ETLDUMP REMAP_SCHEMA=scott:liuyy_001
注：数据泵只能在oracle服务端使用，此处可以备份多个加条件的表
1、创建DIRECTORY
create directory etl_dump as 'D:\oracle\dir_dp';
2、授权
Grant read,write on directory etl_dump to etl_qy;
3、备份
expdp scott/tiger@orcl directory=ETLDUMP dumpfile=aaq1.dmp tables=emp,dept QUERY = 'EMP:"where deptno =20"','DEPT:"where deptno <=20 and deptno >=10"'
4、恢复
impdp liuyy_001/liuyy_001@orcl dumpfile = aaq1.dmp tables = emp,dept directory=ETLDUMP REMAP_SCHEMA=scott:liuyy_001
1572
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
