EXP-00011: XX.tab does not exist

来源：互联网发布：怎么查看淘宝小号满月编辑：程序博客网时间：2024/06/03 19:34

测试环境：11.2.0.1.0 Linux x86 64-bit
现象：空表，记录为0的表导出会报错。
导出如下：
D:\app\product\11.2.0\dbhome_1\BIN>exp labtt/labtt@192.168.101.127/orcl tables=(TE
ST_TIME,TEST_FR,my_test) FILE = D:\TEST.DMP LOG=TEST.LOG
Export: Release 11.2.0.1.0 - Production on Thu Nov 14 18:05:43 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table TEST_TIME 9 rows exported
. . exporting table TEST_FR 4 rows exported
EXP-00011: LABTT.MY_TEST does not exist
Export terminated successfully with warnings.

导入如下：
D:\app\product\11.2.0\dbhome_1\BIN>imp lwh/LWH@192.168.101.127/orcl tables=(TE
ST_TIME,TEST_FR,my_test) FILE = D:\TEST.DMP LOG=lwh.LOG
Import: Release 11.2.0.1.0 - Production on Thu Nov 14 18:12:06 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V11.02.00 via conventional path
Warning: the objects were exported by LABTT, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing LABTT's objects into LWH
. importing LABTT's objects into LWH
. . importing table "TEST_TIME" 9 rows imported
. . importing table "TEST_FR" 4 rows imported
IMP-00033: Warning: Table "MY_TEST" not found in export file
Import terminated successfully with warnings.

查看lwh下的表，没有MY_TEST。

总结：
看样子exp对延迟段创建的表，有一定影响。还是expdp靠谱，但是expdp又必须在服务器端执行。
如果要用exp，deferred_segment_creation又必须设置为false,这样新特性有没有利用。
所以要用exp导出，我都是先把表结构导出，然后再用exp，imp这么执行，这样就不怕空记录的表了。

我觉得应该在导出的时候oracle应该要把表定义导出。这样exp就完美了。

0 0