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就完美了。
