Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2837831
  • 博文数量: 599
  • 博客积分: 16398
  • 博客等级: 上将
  • 技术积分: 6875
  • 用 户 组: 普通用户
  • 注册时间: 2009-11-30 12:04
个人简介

WINDOWS下的程序员出身,偶尔也写一些linux平台下小程序, 后转行数据库行业,专注于ORACLE和DB2的运维和优化。 同时也是ios移动开发者。欢迎志同道合的朋友一起研究技术。 数据库技术交流群:58308065,23618606

文章分类

全部博文(599)

文章存档

2014年(12)

2013年(56)

2012年(199)

2011年(105)

2010年(128)

2009年(99)

分类: Oracle

2011-11-05 15:16:53

11G引入了INTERVAL分区,但是INTERVAL分区却不支持EXP导出,只支持DATA PUMP的导出。


SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL> conn scott/oracle
Connected.

Session altered.

SQL> DROP TABLE T PURGE;

Table dropped.

SQL> CREATE TABLE T(ID INT,NAME VARCHAR2(20))
  2  PARTITION BY RANGE(ID)
  3  (
  4  PARTITION P1 VALUES LESS THAN(10),
  5  PARTITION P2 VALUES LESS THAN(20));

Table created.

SQL> insert into t values(1);
insert into t values(1)
            *
ERROR at line 1:
ORA-00947: not enough values


SQL> insert into t values(1,'a');

1 row created.

SQL> insert into t values(11,'b');

1 row created.

SQL> commit;

Commit complete.

SQL> ! exp scott/oracle file=t.dmp tables=t

Export: Release 11.2.0.1.0 - Production on Sat Nov 5 15:10:26 2011

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 US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                              T
. . exporting partition                             P1          1 rows exported
. . exporting partition                             P2          1 rows exported
Export terminated successfully without warnings.

SQL> alter table t set inverval (10);
alter table t set inverval (10)
                  *
ERROR at line 1:
ORA-02000: missing UNUSED keyword


SQL> alter table t set interval(10);

Table altered.

SQL> ! exp scott/oracle file=t.dmp tables=t

Export: Release 11.2.0.1.0 - Production on Sat Nov 5 15:10:59 2011

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 US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
EXP-00113: Feature New Composite Partitioning Method is unsupported. Table SCOTT.T could not be exported
Export terminated successfully with warnings.

可以看到一旦表设置为INTERVAL分区,采用EXP就不能导出了。

SQL> ! oerr exp 113
00113, 00000, "Feature %s is unsupported. %s %s.%s could not be exported"
// *Cause:  Export does not contain the required support for this feature.
// *Action: Use Oracle Data Pump Utility

看来ORACLE也在逐步废弃EXP导出工具了。

阅读(8252) | 评论(1) | 转发(0) |
给主人留下些什么吧!~~

killeve2013-06-26 08:30:40

那如何导出呢?