Reason for ORA-00439: feature not enabled: Partitioning

Error Description:
Create table command filed with following error.
CREATE TABLE EMP
*
ERROR at line 1:
ORA-00439: feature not enabled: Partitioning

Problem Description
The database portioning option works only with the enterprise edition not with the standard edition.
This partition feature requires the Oracle licensing. Please verify your database version following SQL commands.
You can check your oracle version using following query.
1.   Standard Edition
$ sqlplus / as sysdba
SQL >select * from v$version


BANNER
-------------------------------------------------------------
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
2.   Enterprise Edition
SQL> select * from v$version;

BANNER
------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Also, you can verify whether the partitioning is enabled or not by using the following query.

SQL> COL PARAMETER FOR A30
SQL> COL VALUE FOR A30
SQL> select * from v$option where parameter = 'Partitioning';

PARAMETER                      VALUE
------------------------------ ------------------------------

Partitioning                   FALSE
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google