[20170315]11.2.0.4 exp可以导出空表.txt

最新推荐文章于 2024-09-22 11:17:00 发布

weixin_33709609

最新推荐文章于 2024-09-22 11:17:00 发布

阅读量75

点赞数

文章标签：数据库

原文链接：https://yq.aliyun.com/articles/279489

版权

[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)