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

重新导入失败的表。

ITPub博客

转：启用分区功能

最新文章