oracle的多个exclude,expdp 中使用exclude and include(两个实例)

都是在Windows下做测试的：

C:\Users\Admin.LONG1-LI>expdp scott/bruce123 directory=temp_dir dumpfile=tt_in.dmp EXCLUDE=TABLE:\"in(select table_name from user_tables wh

re table_name like 'TT%')\"

Export: Release 10.2.0.1.0 - Production on Thursday, 24 September, 2015 10:48:56

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Starting "SCOTT"."SYS_EXPORT_SCHEMA_01":  scott/******** directory=temp_dir dumpfile=tt_in.dmp EXCLUDE=TABLE:"in(select table_name from use

_tables where table_name like 'TT%')"

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

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

. . exported "SCOTT"."EMP"                               7.820 KB      14 rows

. . exported "SCOTT"."SALGRADE"                          5.585 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:

E:\APP\BRUCE\TT_IN.DMP

Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at 10:49:06

C:\Users\Admin.LONG1-LI>expdp scott/bruce123 directory=temp_dir dumpfile=tt_in.dmp INCLUDE=TABLE:\"in(select table_name from user_tables whe

re table_name like 'TT%')\"

Export: Release 10.2.0.1.0 - Production on Thursday, 24 September, 2015 10:50:01

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Starting "SCOTT"."SYS_EXPORT_SCHEMA_01":  scott/******** directory=temp_dir dumpfile=tt_in.dmp INCLUDE=TABLE:"in(select table_name from user

_tables where table_name like 'TT%')"

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 128 KB

Processing object type SCHEMA_EXPORT/TABLE/TABLE

. . exported "SCOTT"."TT1"                               4.945 KB       3 rows

. . exported "SCOTT"."TT2"                               4.929 KB       3 rows

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

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

Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:

E:\APP\BRUCE\TT_IN.DMP

Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at 10:50:09