Oracle imp恢复数据库时遭遇ORA-00439: feature not enabled: Partitioning

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:432

在对Oracle数据库进行imp导入的时候遇到如下问题:

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
Enterprise User 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 Release 9.2.0.8.0 - 64bit Production
With the Oracle Label Security and OLAP options
JServer Release 9.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,正确。

重新导入失败的表。

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】