EXP-00011: XX.tab does not exist

最新推荐文章于 2022-11-29 20:28:02 发布

转载最新推荐文章于 2022-11-29 20:28:02 发布 · 403 阅读

标签

#数据库

本文讨论了使用Oracle数据库导出(exp)和导入(imp)过程中遇到的问题，特别是对于延迟段创建的表，exp可能无法正确处理，并提供了解决方案。建议在导出时先导出表结构，然后通过exp和imp执行，以避免空记录表导致的错误。

测试环境：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就完美了。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25027760/viewspace-776619/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25027760/viewspace-776619/