Oracle备份恢复：imp遭遇ORA-00439: feature not enabled: Partitioning

在进行Oracle数据库备份导入的时候遇到如下问题：

IMP-00017: following statement failed with ORACLE error 439:
"CREATE TABLE "TABLE1_PB1"
……
……
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Partitioning

查询v$option视图，发现Partitioning为FALSE，如下图：：

SQL> select * from v$option;

PARAMETER                                         VALUE
-------------------------------------------------- --------------------
Partitioning                                      FALSE
Objects                                           TRUE
Real Application Clusters                         FALSE
Advanced replication                              TRUE
Bit-mapped indexes                                TRUE
Connection multiplexing                           TRUE
Connection pooling                                TRUE
Database queuing                                  TRUE
Incremental backup and recovery                   TRUE
Instead-of triggers                               TRUE
Parallel backup and recovery                      TRUE
Parallel execution                                TRUE
Parallel load                                     TRUE
Point-in-time tablespace recovery                 TRUE
Fine-grained access control                       TRUE
Proxy authentication/authorization                TRUE
Change Data Capture                               TRUE
Plan Stability                                    TRUE
Online Index Build                                TRUE
Coalesce Index                                    TRUE
Managed Standby                                   TRUE
Materialized view rewrite                         TRUE
Materialized view warehouse refresh               TRUE
Database resource manager                         TRUE
Spatial                                           TRUE
Visual Information Retrieval                      TRUE
Export transportable tablespaces                  TRUE
Transparent Application Failover                  TRUE
Fast-Start Fault Recovery                         TRUE
Sample Scan                                       TRUE
Duplexed backups                                  TRUE
Java                                              TRUE
OLAP Window Functions                             TRUE
Block Media Recovery                              TRUE
Fine-grained Auditing                             TRUE
Application Role                                  TRUE
EnterpriseUser Security                          TRUE
Oracle Data Guard                                 TRUE
Oracle Label Security                             TRUE
OLAP                                              TRUE
Heap segment compression                          TRUE
Join index                                        TRUE
Trial Recovery                                    TRUE
Oracle Data Mining                                FALSE
Online Redefinition                               TRUE
Streams                                           TRUE
File Mapping                                      TRUE

47 rows selected.

检查数据库版本，是企业版：
Oracle9i Enterprise Edition Release9.2.0.8.0 - 64bit Production
With the Oracle Label Security and OLAP options
JServer Release9.2.0.8.0 - Production

启用Partitioning属性一下：
SQL> shutdown immediate;
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk part_on
$ make -f ins_rdbms.mk ioracle
SQL>startup

重新检查Partitioning状态，结果为TRUE，正确。

重新导入失败的表。更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Oracle权限管理：After Revoking DBA RoleOracle 11g R2单机升级步骤相关资讯 Oracle备份恢复

Oracle数据库物理文件备份/恢复（07/20/2015 20:53:07）
Oracle 数据备份与恢复（04/26/2014 09:35:49）
Oracle 10g控制文件备份到文件与手（02/23/2014 09:03:34）

Oracle使用句柄实现特定场景的无备（11/24/2014 14:07:02）
Oracle控制文件的备份、恢复以及多（04/10/2014 15:15:06）
Oracle用控制文件旧备份恢复后数据（08/19/2013 09:38:27）

本文评论查看全部评论（0）