oracle11g expdp空表,expdp会导出空表

在11g中，expdp会把空表也导出，虽然还没有分配segment

exp是找不到没有分配segment的表

SQL> conn song/song

已连接。

SQL> drop table test purge;

表已删除。

SQL> create table test (id number);

表已创建。

SQL> SELECT COUNT(*) FROM DBA_SEGMENTS WHERE

SEGMENT_NAME='TEST' AND OWNER='SONG';

COUNT(*)

----------

0

SQL> EXIT

从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -

64bit Production

With the Partitioning, OLAP, Data Mining and Real Application

Testing options 断开

[oracle11g@ogg2 ~]$ expdp song/song directory=DATA_PUMP_DIR

dumpfile=t.dmp tables=test

Export: Release 11.2.0.1.0 - Production on 星期二 5月 6 21:29:54

2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.

All rights reserved.

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

- 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application

Testing options

启动 "SONG"."SYS_EXPORT_TABLE_01":

song/******** directory=DATA_PUMP_DIR

dumpfile=t.dmp tables=test

正在使用 BLOCKS 方法进行估计...

处理对象类型 TABLE_EXPORT/TABLE/TABLE_DATA

使用 BLOCKS 方法的总估计: 0 KB

处理对象类型 TABLE_EXPORT/TABLE/TABLE

. . 导出了 "SONG"."TEST"  0 KB

0 行

已成功加载/卸载了主表

"SONG"."SYS_EXPORT_TABLE_01"

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

SONG.SYS_EXPORT_TABLE_01 的转储文件集为:

/ora11g/app/oracle/admin/ora11g/dpdump/t.dmp

作业 "SONG"."SYS_EXPORT_TABLE_01" 已于 21:30:12 成功完成

[oracle11g@ogg2 ~]$ sqlplus song/song

SQL*Plus: Release 11.2.0.1.0 Production on 星期二 5月 6 21:30:34

2014

Copyright (c) 1982, 2009, Oracle.  All rights

reserved.

连接到:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -

64bit Production

With the Partitioning, OLAP, Data Mining and Real Application

Testing options

SQL> drop table test purge;

表已删除。

SQL> exit

从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -

64bit Production

With the Partitioning, OLAP, Data Mining and Real Application

Testing options 断开

[oracle11g@ogg2 ~]$ impdp song/song directory=DATA_PUMP_DIR

dumpfile=t.dmp

Import: Release 11.2.0.1.0 - Production on 星期二 5月 6 21:31:03

2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.

All rights reserved.

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

- 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application

Testing options

已成功加载/卸载了主表

"SONG"."SYS_IMPORT_FULL_01"

启动 "SONG"."SYS_IMPORT_FULL_01":

song/******** directory=DATA_PUMP_DIR

dumpfile=t.dmp

处理对象类型 TABLE_EXPORT/TABLE/TABLE

处理对象类型 TABLE_EXPORT/TABLE/TABLE_DATA

. . 导入了 "SONG"."TEST"  0 KB

0 行

作业 "SONG"."SYS_IMPORT_FULL_01" 已于 21:31:21 成功完成

[oracle11g@ogg2 ~]$ sqlplus song/song

SQL*Plus: Release 11.2.0.1.0 Production on 星期二 5月 6 21:31:33

2014

Copyright (c) 1982, 2009, Oracle.  All rights

reserved.

连接到:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -

64bit Production

With the Partitioning, OLAP, Data Mining and Real Application

Testing options

SQL> select * from test;

未选定行

SQL> SELECT COUNT(*) FROM DBA_SEGMENTS WHERE

SEGMENT_NAME='TEST' AND OWNER='SONG';

COUNT(*)

----------

0

[oracle11g@ogg2 ~]$ exp song/song tables=test

file=/ora11g/test.dmp

Export: Release 11.2.0.1.0 - Production on 星期二 5月 6 21:37:39

2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.

All rights reserved.

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

- 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application

Testing options

已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集

即将导出指定的表通过常规路径...

EXP-00011: SONG.TEST 不存在

导出成功终止, 但出现警告。