首页>SQL技巧教程>文章详情

EXP-00011: XX.tab does not exist

3/7/2017
1390
测试环境: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就完美了。