EXP-00011: XX.tab does not exist
2024-07-21 02:53:06
供稿：网友
测试环境：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=(TEST_TIME,TEST_FR,my_test) FILE = D:/TEST.DMP LOG=TEST.LOGExport: Release 11.2.0.1.0 - Production on Thu Nov 14 18:05:43 2013Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bitProductionWith the Partitioning, OLAP, Data Mining and Real application Testing optionsExport done in ZHS16GBK character set and AL16UTF16 NCHAR character setAbout to export specified tables via Conventional Path .... . exporting table TEST_TIME 9 rows exported. . exporting table TEST_FR 4 rows exportedEXP-00011: LABTT.MY_TEST does not existExport terminated successfully with warnings.导入如下：D:/app/product/11.2.0/dbhome_1/BIN>imp lwh/LWH@192.168.101.127/orcl tables=(TEST_TIME,TEST_FR,my_test) FILE = D:/TEST.DMP LOG=lwh.LOGImport: Release 11.2.0.1.0 - Production on Thu Nov 14 18:12:06 2013Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bitProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport file created by EXPORT:V11.02.00 via conventional pathWarning: the objects were exported by LABTT, not by youimport 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 importedIMP-00033: Warning: Table "MY_TEST" not found in export fileImport terminated successfully with warnings.查看lwh下的表，没有MY_TEST。总结：看样子exp对延迟段创建的表，有一定影响。还是expdp靠谱，但是expdp又必须在服务器端执行。如果要用exp，deferred_segment_creation又必须设置为false,这样新特性有没有利用。所以要用exp导出，我都是先把表结构导出，然后再用exp，imp这么执行，这样就不怕空记录的表了。我觉得应该在导出的时候oracle应该要把表定义导出。这样exp就完美了。
