Oracle日常运维之带where查询条件的expdp/impdp

create table test5 ecology.test5 (id int); 

insert into ecology.test5 vaules (1);
insert into ecology.test5 vaules (2);
insert into ecology.test5 vaules (3);
insert into ecology.test5 vaules (4);
insert into ecology.test5 vaules (5);
commit;

create ditectory mydata as '/data1/expdp';
grant read,write on directory mydata to ecology;

[oracle@oracle expdp]$ expdp ecology/ecology directory=mydata dumpfile=test5.dmp tables=test5 query='test5:"where id =1"'
Export: Release 11.2.0.1.0 - Production on Mon Nov 11 02:26:08 2019
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "ECOLOGY"."SYS_EXPORT_TABLE_01":  ecology/******** directory=mydata dumpfile=test5.dmp tables=test5 query=test5:"where id =1" 
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "ECOLOGY"."TEST5"                           5.023 KB       1 rows
Master table "ECOLOGY"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded


******************************************************************************


Dump file set for ECOLOGY.SYS_EXPORT_TABLE_01 is:
  data1/expdp/test5.dmp
Job "ECOLOGY"."SYS_EXPORT_TABLE_01" successfully completed at 02:26:19

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


Import: Release 11.2.0.1.0 - Production on Mon Nov 11 02:38:29 2019
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "ECOLOGY"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "ECOLOGY"."SYS_IMPORT_TABLE_01":  ecology/******** directory=mydata dumpfile=test5-1.dmp tables=test5 content=data_only query=test5:"where id=1" 
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "ECOLOGY"."TEST5"                           5.054 KB       1 out of 5 rows
Job "ECOLOGY"."SYS_IMPORT_TABLE_01" successfully completed at 02:38:31