This discussion is archived
11 Replies Latest reply: May 27, 2013 2:06 AM by 864103 RSS

ORA-00439: feature not enabled: Partitioning

864103 Newbie
Currently Being Moderated
Hi ,

oracle 11.2.2 ASM RAC under OEL 5.6
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

SQL>
i don't have enough license to create partition ??

SQL> CREATE TABLE big_table2 (
  2    id            NUMBER(10),
  3    created_date  DATE,
  4    lookup_id     NUMBER(10),
  5    data          VARCHAR2(50)
)
PARTITION BY RANGE (created_date)
  6    7    8  (PARTITION JAN VALUES LESS THAN (TO_DATE('01/01/2013', 'DD/MM/YYYY')),
  9   PARTITION FEB VALUES LESS THAN (TO_DATE('01/02/2003', 'DD/MM/YYYY')),
 10   PARTITION MAX VALUES LESS THAN (MAXVALUE));
CREATE TABLE big_table2 (
*
ERROR at line 1:
ORA-00439: feature not enabled: Partitioning
or i can easy to enable it without additional license ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points