Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

0

好友

9

主题
1#
发表于 2014-12-22 21:40:05 | 查看: 11218| 回复: 1
环境:windows7 + oracle 11.2.0.3.0

C:\Users\Bill>exp system/oracle tables=sys.tbl_test file=test.dmp

Export: Release 11.2.0.3.0 - Production on Mon Dec 22 21:33:28 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.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 ...
Current user changed to SYS
EXP-00113: Feature New Composite Partitioning Method is unsupported. Table SYS.TBL_TEST could not be exported
Export terminated successfully with warnings.


C:\Users\Bill>

我在网上看到,这个错误是由于分区表使用了interval特性导致的,但我的这个表根本没有使用这个特性,给出创建表的脚本,创建表后导出空表也报这个错。

list-range part.zip

8.87 KB, 下载次数: 601

2#
发表于 2014-12-25 11:01:24
EXP-00113: Feature New Composite Partitioning Method is unsupported. Table SYS.TBL_TEST could not be exported
Export terminated successfully with warnings.

==>  New Composite Partitioning  这里应当说的是 组合分区  即你用的range-list分区


[oracle@oel8 ~]$ 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 Data Pump Utility

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-5-19 18:32 , Processed in 0.053655 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569