针对 expdp 导出表的部分数据,测试如下
在 /home/oracle 目录下新建一个 expdp.par 文件,文件内容如下:
directory=expdir
dumpfile=scott_part.dmp
logfile=part_scott.log
tables=tt
query=tt:"where object_id<=20"
然后执行下述命令,导出tt表的部分数据
[oracle@VM-10 ~]$ expdp scott/tiger parfile=/home/oracle/expdp.par
Export: Release 10.2.0.4.0 - 64bit Production on Wednesday, 09 October, 2013 14:54:05
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/******** parfile=/home/oracle/expdp.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 45 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "SCOTT"."TT" 19.96 KB
152 rows
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
/oradata/expdir/scott_part.dmp
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 14:54:09
结果显示有 152 rows导出,可以从数据库中验证该结果
SQL> select count(*) from tt where object_id<=20;
COUNT(*)
----------
152
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24862808/viewspace-774039/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24862808/viewspace-774039/