测试
expdp
1> 建表
create table test5 ecology.test5 (id int);
2> 插入 5 条数据
- 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;
3> 创建 directory
- create ditectory mydata as '/data1/expdp';
- grant read,write on directory mydata to ecology;
4> 导出 id 为 1 的数据
- [[email protected] 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
- impdp
首先导出 test5 的全部数据 (省略)
以下为导出命令
- [[email protected] 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
来源: http://www.bubuko.com/infodetail-3282657.html