文章內(nèi)容

Oracle備份恢復(fù)：imp遭遇ORA-00439: feature not enabled: Pa

發(fā)布時間: 2012/9/6 17:19:47

在進行Oracle數(shù)據(jù)庫備份導(dǎo)入的時候遇到如下問題：

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視圖，發(fā)現(xiàn)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.

檢查數(shù)據(jù)庫版本，是企業(yè)版：
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狀態(tài)，結(jié)果為TRUE，正確。

重新導(dǎo)入失敗的表。