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