[20170315]11.2.0.4 exp可以导出空表.txt
--链接http://www.itpub.net/thread-2084282-1-1.html,11.2.0.4可以使用exp导出空表,没有问题,测试看看.
SCOTT@book> @ &r/ver
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
SCOTT@book> create table deptx as select * from dept where 1=2;
Table created.
SCOTT@book> show parameter defer
NAME TYPE VALUE
------------------------- ------- ------
deferred_segment_creation boolean TRUE
$ exp scott/book tables=deptx
Export: Release 11.2.0.4.0 - Production on Wed Mar 15 11:51:17 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.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 DEPTX 0 rows exported
Export terminated successfully without warnings.
SCOTT@book> drop table deptx purge ;
Table dropped.
$ imp scott/book file=expdat.dmp full=y
Import: Release 11.2.0.4.0 - Production on Wed Mar 15 11:52:11 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.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
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing SCOTT's objects into SCOTT
. importing SCOTT's objects into SCOTT
. . importing table "DEPTX" 0 rows imported
Import terminated successfully without warnings.
SCOTT@book> @ &r/desc deptx
Name Null? Type
------- -------- ----------------------------
1 DEPTNO NUMBER(2)
2 DNAME VARCHAR2(14)
3 LOC VARCHAR2(13)
