Reason for ORA-00439: feature not enabled: Partitioning

advertisements

_____________________________________________________________________________________________________________________

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

_____________________________________________________________________________________________________________________

Archive