所有表导出过滤条件一样

[oracle@centos5 ~]$ expdp cheese/cheese schemas=cheese directory=ff query=\"where rownum \< 1 \";

 
Export: Release 10.2.0.1.0 - 64bit Production on Saturday, 22 December, 2012 0:38:05
 
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
 
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
FLASHBACK automatically enabled to preserve database integrity.
Starting "CHEESE"."SYS_EXPORT_SCHEMA_01":  cheese/******** schemas=cheese directory=ff query="where rownum < 1 " 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 101.5 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
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/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "CHEESE"."APP1"                             8.656 KB       0 rows
. . exported "CHEESE"."INDEXTABLE"                       7.062 KB       0 rows
. . exported "CHEESE"."PARLL"                            5.539 KB       0 rows
. . exported "CHEESE"."LOGMNR_CONTENTS"                  23.05 KB       0 rows
. . exported "CHEESE"."SYS_EXPORT_FULL_01"               30.16 KB       0 rows
. . exported "CHEESE"."TEST2"                            8.656 KB       0 rows
. . exported "CHEESE"."AM1"                              5.218 KB       0 rows
. . exported "CHEESE"."TESTBLOCK"                        5.218 KB       0 rows
 
Master table "CHEESE"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for CHEESE.SYS_EXPORT_SCHEMA_01 is:
  /u01/expdat.dmp
Job "CHEESE"."SYS_EXPORT_SCHEMA_01" successfully completed at 00:38:38
 
 
[oracle@centos5 u01]$ expdp cheese/cheese schemas=cheese directory=ff query="where rownum<2";
 
Export: Release 10.2.0.1.0 - 64bit Production on Saturday, 22 December, 2012 0:55:10
 
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
 
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39035: Data filter SUBQUERY has already been specified.
 
[oracle@centos5 u01]$ expdp cheese/cheese schemas=cheese directory=ff query=cheese.'"where rownum<2"'';> 
[oracle@centos5 u01]$ expdp cheese/cheese schemas=cheese directory=ff query='"where rownum<2"';
 
Export: Release 10.2.0.1.0 - 64bit Production on Saturday, 22 December, 2012 0:56:58
 
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
 
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
FLASHBACK automatically enabled to preserve database integrity.
Starting "CHEESE"."SYS_EXPORT_SCHEMA_01":  cheese/******** schemas=cheese directory=ff query="where rownum<2" 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 101.5 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
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/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "CHEESE"."APP1"                             8.734 KB       1 rows
. . exported "CHEESE"."INDEXTABLE"                       7.109 KB       1 rows
. . exported "CHEESE"."PARLL"                            5.570 KB       1 rows
. . exported "CHEESE"."LOGMNR_CONTENTS"                  23.45 KB       1 rows
. . exported "CHEESE"."SYS_EXPORT_FULL_01"               30.52 KB       1 rows
. . exported "CHEESE"."TEST2"                            8.734 KB       1 rows
. . exported "CHEESE"."AM1"                              5.234 KB       1 rows
. . exported "CHEESE"."TESTBLOCK"                        5.234 KB       1 rows
Master table "CHEESE"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for CHEESE.SYS_EXPORT_SCHEMA_01 is:
  /u01/expdat.dmp
Job "CHEESE"."SYS_EXPORT_SCHEMA_01" successfully completed at 00:57:14
 
只对某个表进行条件过滤
[oracle@centos5 u01]$  expdp cheese/cheese schemas=cheese directory=ff query=app1:'"where rownum<2"';
 
Export: Release 10.2.0.1.0 - 64bit Production on Saturday, 22 December, 2012 1:06:49
 
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
 
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
FLASHBACK automatically enabled to preserve database integrity.
Starting "CHEESE"."SYS_EXPORT_SCHEMA_01":  cheese/******** schemas=cheese directory=ff query=app1:"where rownum<2" 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 101.5 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
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/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "CHEESE"."APP1"                             8.734 KB       1 rows
. . exported "CHEESE"."INDEXTABLE"                       1.774 MB   30059 rows
. . exported "CHEESE"."PARLL"                            2.009 MB   50385 rows
. . exported "CHEESE"."LOGMNR_CONTENTS"                  916.1 KB    1106 rows
. . exported "CHEESE"."SYS_EXPORT_FULL_01"               167.7 KB    1652 rows
. . exported "CHEESE"."TEST2"                            91.89 KB    1000 rows
. . exported "CHEESE"."AM1"                              8.773 KB     200 rows
. . exported "CHEESE"."TESTBLOCK"                         5.25 KB       3 rows
. . exported "CHEESE"."APP"                                  0 KB       0 rows
. . exported "CHEESE"."APP2"                                 0 KB       0 rows
. . exported "CHEESE"."T"                                    0 KB       0 rows
. . exported "CHEESE"."TEST"                                 0 KB       0 rows
. . exported "CHEESE"."TR"                                   0 KB       0 rows
. . exported "CHEESE"."T_LOB"                                0 KB       0 rows
Master table "CHEESE"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for CHEESE.SYS_EXPORT_SCHEMA_01 is:
  /u01/expdat.dmp
Job "CHEESE"."SYS_EXPORT_SCHEMA_01" successfully completed at 01:07:05