使用include=TABLE:\" in \(select table_name from user_tables where table_name like \'MACLEAN_T1\%\' or table_name like \'MACLEAN_T2\%\' \) \"
这种方法即可
SQL> create table maclean_t1abc(t1 int);
Table created.
SQL> create table maclean_t2abc(t1 int);
Table created.
[oracle@vrh8 ~]$ expdp maclean/oracle dumpfile=temp:mac.dmp schemas=maclean include=TABLE:\" in \(select table_name from user_tables where table_name like \'MACLEAN_T1\%\' or table_name like \'MACLEAN_T2\%\' \) \"
Export: Release 10.2.0.5.0 - 64bit Production on Tuesday, 23 April, 2013 8:16:44
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "MACLEAN"."SYS_EXPORT_SCHEMA_01": maclean/******** dumpfile=temp:mac.dmp schemas=maclean include=TABLE:" in (select table_name from user_tables where table_name like 'MACLEAN_T1%' or table_name like 'MACLEAN_T2%' ) "
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported "MACLEAN"."MACLEAN_T1ABC" 0 KB 0 rows
. . exported "MACLEAN"."MACLEAN_T2ABC" 0 KB 0 rows
Master table "MACLEAN"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for MACLEAN.SYS_EXPORT_SCHEMA_01 is:
/tmp/mac.dmp
Job "MACLEAN"."SYS_EXPORT_SCHEMA_01" successfully completed at 08:16:49
这种方法即可
SQL> create table maclean_t1abc(t1 int);
Table created.
SQL> create table maclean_t2abc(t1 int);
Table created.
[oracle@vrh8 ~]$ expdp maclean/oracle dumpfile=temp:mac.dmp schemas=maclean include=TABLE:\" in \(select table_name from user_tables where table_name like \'MACLEAN_T1\%\' or table_name like \'MACLEAN_T2\%\' \) \"
Export: Release 10.2.0.5.0 - 64bit Production on Tuesday, 23 April, 2013 8:16:44
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "MACLEAN"."SYS_EXPORT_SCHEMA_01": maclean/******** dumpfile=temp:mac.dmp schemas=maclean include=TABLE:" in (select table_name from user_tables where table_name like 'MACLEAN_T1%' or table_name like 'MACLEAN_T2%' ) "
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported "MACLEAN"."MACLEAN_T1ABC" 0 KB 0 rows
. . exported "MACLEAN"."MACLEAN_T2ABC" 0 KB 0 rows
Master table "MACLEAN"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for MACLEAN.SYS_EXPORT_SCHEMA_01 is:
/tmp/mac.dmp
Job "MACLEAN"."SYS_EXPORT_SCHEMA_01" successfully completed at 08:16:49
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27788822/viewspace-759135/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27788822/viewspace-759135/