oracle over pa,Oracle备份恢复：imp遭遇ORA-00439: feature not enabled: Pa

在进行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，正确。

重新导入失败的表。

本文出自：亿恩科技【www.enkj.com】