oracle expdp导出记录,Oracle Expdp 表单记录导出

parfile内容是：

QUERY=emp:"WHERE rownum<4"

NOLOGFILE=y

DIRECTORY=DATA_PUMP_DIR

DUMPFILE=exp1.dmp

D:/Temp>expdp scott/tiger parfile=emp_query.par reuse_dumpfiles=y

Export: Release 11.1.0.6.0 - Production on Thursday, 26 February, 2009 18:16:59

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production

With the Partitioning, Oracle Label Security, OLAP, Oracle Database Vault

and Real Application Testing options

Starting "SCOTT"."SYS_EXPORT_SCHEMA_01":  scott/******** parfile=emp_query.par reuse_dumpfiles=y

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 192 KB

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA

. . exported "SCOTT"."DEPT"                              5.937 KB      4 rows

. . exported "SCOTT"."EMP"                              8.125 KB      3 rows

. . exported "SCOTT"."SALGRADE"                          5.867 KB      5 rows

. . exported "SCOTT"."BONUS"                                0 KB      0 rows

Master table "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

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

Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:

D:/ORACLE/ADMIN/ORCL11G/DPDUMP/EXP1.DMP

Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at 18:17:32

--------------------自己测试

--BHDATAR_query.par 参数文件 的 内容

Tables=resourceinfo

QUERY="where FILENAME='ZHCXBB'"

DIRECTORY=DPC

Job_Name=Blob_expdp

NOLOGFILE=y

DUMPFILE=BHDATAresourceinfo1.dmp

logfile =BHDATAresourceinfo1.Log

reuse_dumpfiles=y

-----------------导出语句

expdp bhdata/bhdata@orcl parfile=E:/dp/BHDATAR_query.par