expdp 使用QUERY 导出部分数据。

AIX , ORACLE 11G:

expdp hldba/dba123@appdev directory=EXP_DIR log=tmp1.log dumpfile=tmp1.dmp tables=tp1 query="" where OWNER='HLDBA' " "

-- 注意，双引号正确使用方法，SHELL需要一个，EXPDP也需要一个。

－－－LOG信息如下：

/home/oracle/dump_data$log dumpfile=tmp1.dmp tables=tp1 query="" where OWNER='HLDBA' " " <

Export: Release 11.2.0.1.0 - Production on Wed Apr 13 12:02:58 2011

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 and OLAP options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "log=tmp1.log" Location: Command Line, Replaced with: "logfile=tmp1.log"
Legacy Mode has set reuse_dumpfiles=true parameter.
Starting "HLDBA"."SYS_EXPORT_TABLE_01": hldba/********@appdev directory=EXP_DIR logfile=tmp1.log dumpfile=tmp1.dmp tables=tp1 query=" where OWNER='HLDBA' " reuse_dumpfiles=true
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 10 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "HLDBA"."TP1":"P2" 11.57 KB 10 rows
. . exported "HLDBA"."TP1":"P1" 10.70 KB 0 rows
Master table "HLDBA"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for HLDBA.SYS_EXPORT_TABLE_01 is:
/home/oracle/dump_data/tmp1.dmp
Job "HLDBA"."SYS_EXPORT_TABLE_01" successfully completed at 12:03:08

/home/oracle/dump_data$

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/350519/viewspace-1048602/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/350519/viewspace-1048602/