11 Replies Latest reply: May 27, 2013 4:06 AM by 864103 RSS

    ORA-00439: feature not enabled: Partitioning

    864103
      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 ?