oracle Expdp带条件,带where查询条件的expdp/impdp

测试

expdp

1> 建表

1 create table test5 ecology.test5 (id int);

2> 插入5条数据

1 insert into ecology.test5 vaules (1);

2 insert into ecology.test5 vaules (2);

3 insert into ecology.test5 vaules (3);

4 insert into ecology.test5 vaules (4);

5 insert into ecology.test5 vaules (5);

6 commit;

3> 创建directory

1 create ditectory mydata as '/data1/expdp';

2 grant read,write on directory mydata to ecology;

4> 导出id为1的数据

1 [oracle@oracle expdp]$ expdp ecology/ecology directory=mydata dumpfile=test5.dmp tables=test5 query='test5:"where id =1"'

2 Export: Release 11.2.0.1.0 - Production on Mon Nov 11 02:26:08 2019

3 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

4 Connected to: Oracle Database 11g Enterprise Edition Release 11.