12 Replies Latest reply on Nov 21, 2011 1:21 AM by 894206

    How do I enabled the Partitioning feature in SQL Developer?

    894206
      When I tried running this script, from one of Oracle's training site:

      ----------------------------
      -- DROP TABLE "CUSTOMERS_PART";
      ----------------------------
      DROP TABLE "CUSTOMERS_PART";
      --------------------------------------------------------
      --  DDL for Table CUSTOMERS_PART
      --------------------------------------------------------
      CREATE TABLE "CUSTOMERS_PART"
      *(     "CUSTOMER_ID" NUMBER(6,0),
           "CUST_FIRST_NAME" VARCHAR2(20),
           "CUST_LAST_NAME" VARCHAR2(20),
           "NLS_TERRITORY" VARCHAR2(30),
           "CREDIT_LIMIT" NUMBER(9,2)* )
      PARTITION BY RANGE ("CREDIT_LIMIT")
      SUBPARTITION BY LIST ("NLS_TERRITORY")
      SUBPARTITION TEMPLATE (
      SUBPARTITION "EAST" values ( 'CHINA', 'JAPAN', 'INDIA', 'THAILAND' ),
      SUBPARTITION "WEST" values ( 'AMERICA', 'GERMANY', 'ITALY', 'SWITZERLAND' ),
      SUBPARTITION "OTHER" values ( DEFAULT ) )
      *(PARTITION "P1" VALUES LESS THAN (1000) ,*
      PARTITION "P2"  VALUES LESS THAN (2500) ,
      PARTITION "P3"  VALUES LESS THAN (MAXVALUE) ) ;

      I get this error:

      Error starting at line 10 in command:
      CREATE TABLE "CUSTOMERS_PART"
      *(     "CUSTOMER_ID" NUMBER(6,0),*
      *     "CUST_FIRST_NAME" VARCHAR2(20),*
      *     "CUST_LAST_NAME" VARCHAR2(20),*
      *     "NLS_TERRITORY" VARCHAR2(30),*
      *     "CREDIT_LIMIT" NUMBER(9,2)*
      *)*
      PARTITION BY RANGE ("CREDIT_LIMIT")
      SUBPARTITION BY LIST ("NLS_TERRITORY")
      SUBPARTITION TEMPLATE (
      SUBPARTITION "EAST" values ( 'CHINA', 'JAPAN', 'INDIA', 'THAILAND' ),
      SUBPARTITION "WEST" values ( 'AMERICA', 'GERMANY', 'ITALY', 'SWITZERLAND' ),
      SUBPARTITION "OTHER" values ( DEFAULT ) )
      *(PARTITION "P1" VALUES LESS THAN (1000) ,*
      PARTITION "P2"  VALUES LESS THAN (2500) ,
      PARTITION "P3"  VALUES LESS THAN (MAXVALUE) )

      Error at Command Line:10 Column:0
      Error report:
      SQL Error: ORA-00439: feature not enabled: Partitioning
      *00439. 00000 - "feature not enabled: %s"*
      **Cause: The specified feature is not enabled.*
      **Action: Do not attempt to use this feature.*

      How do I fix this?
        • 1. Re: How do I enabled the Partitioning feature in SQL Developer?
          Srini Chavali-Oracle
          Pl post details of OS and database versions.

          >
          SQL Error: ORA-00439: feature not enabled: Partitioning
          00439. 00000 - "feature not enabled: %s"
          *Cause: The specified feature is not enabled.
          >

          Partitioning is a feature of the database, and has nothing to do with SQL Developer. Pl post the output of the following
          SQL> select * from v$OPTION;
          http://download.oracle.com/docs/cd/E11882_01/server.112/e25513/dynviews_2084.htm#REFRN30167

          Partitioning will need to be enabled first (it is a separately licensed option) before you can execute your create table statement

          http://download.oracle.com/docs/cd/E11882_01/license.112/e10594/editions.htm#CIHBAEID

          http://download.oracle.com/docs/cd/E11882_01/install.112/e24321/post_inst_task.htm#CHDFEIJF
          http://download.oracle.com/docs/cd/E11882_01/install.112/e24186/postcfg.htm#NTDBI2832


          HTH
          Srini
          • 2. Re: How do I enabled the Partitioning feature in SQL Developer?
            894206
            Windows XP Pro SP3
            Oracle 11g ex
            SQL Developer 3.0.04

            SQL> select from v$OPTION;*

            Error starting at line 1 in command:
            SQL> select * from v$OPTION
            Error report:
            Unknown Command
            • 3. Re: How do I enabled the Partitioning feature in SQL Developer?
              sb92075
              post results from following SQL


              SELECT * FROM V$VERSION;
              • 4. Re: How do I enabled the Partitioning feature in SQL Developer?
                894206
                select * from v$VERSION;

                BANNER
                --------------------------------------------------------------------------------
                Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
                PL/SQL Release 11.2.0.2.0 - Production
                CORE     11.2.0.2.0     Production
                TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
                NLSRTL Version 11.2.0.2.0 - Production



                select * from v$OPTION;

                PARAMETER VALUE
                ---------------------------------------------------------------- ----------------------------------------------------------------
                Partitioning FALSE
                Objects TRUE
                Real Application Clusters FALSE
                Advanced replication FALSE
                Bit-mapped indexes FALSE
                Connection multiplexing TRUE
                Connection pooling TRUE
                Database queuing TRUE
                Incremental backup and recovery TRUE
                Instead-of triggers TRUE
                Parallel backup and recovery FALSE
                Parallel execution FALSE
                Parallel load TRUE
                Point-in-time tablespace recovery FALSE
                Fine-grained access control FALSE
                Proxy authentication/authorization TRUE
                Change Data Capture FALSE
                Plan Stability TRUE
                Online Index Build FALSE
                Coalesce Index FALSE
                Managed Standby FALSE
                Materialized view rewrite FALSE
                Database resource manager FALSE
                Spatial FALSE
                Automatic Storage Management FALSE
                Export transportable tablespaces FALSE
                Transparent Application Failover TRUE
                Fast-Start Fault Recovery FALSE
                Sample Scan TRUE
                Duplexed backups FALSE
                Java FALSE
                OLAP Window Functions TRUE
                Block Media Recovery FALSE
                Fine-grained Auditing FALSE
                Application Role FALSE
                Enterprise User Security FALSE
                Oracle Data Guard FALSE
                Oracle Label Security FALSE
                OLAP FALSE
                Basic Compression FALSE
                Join index FALSE
                Trial Recovery FALSE
                Data Mining FALSE
                Online Redefinition FALSE
                Streams Capture FALSE
                File Mapping FALSE
                Block Change Tracking FALSE
                Flashback Table FALSE
                Flashback Database FALSE
                Transparent Data Encryption FALSE
                Backup Encryption FALSE
                Unused Block Compression FALSE
                Oracle Database Vault FALSE
                Result Cache FALSE
                SQL Plan Management FALSE
                SecureFiles Encryption FALSE
                Real Application Testing FALSE
                Flashback Data Archive FALSE
                DICOM FALSE
                Active Data Guard FALSE
                Server Flash Cache FALSE
                Advanced Compression FALSE
                XStream FALSE
                Deferred Segment Creation FALSE

                64 rows selected
                • 5. Re: How do I enabled the Partitioning feature in SQL Developer?
                  585179
                  aojiku01 wrote:
                  select * from v$VERSION;

                  BANNER
                  --------------------------------------------------------------------------------
                  Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
                  PL/SQL Release 11.2.0.2.0 - Production
                  CORE     11.2.0.2.0     Production
                  TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
                  NLSRTL Version 11.2.0.2.0 - Production



                  select * from v$OPTION;

                  PARAMETER VALUE
                  ---------------------------------------------------------------- ----------------------------------------------------------------
                  Partitioning FALSE
                  The partition is not enabled in your database. and since you're using XE edition this feature will not be available


                  Cheers
                  • 6. Re: How do I enabled the Partitioning feature in SQL Developer?
                    894206
                    So how do I enable it. That was the original question I had?
                    • 7. Re: How do I enabled the Partitioning feature in SQL Developer?
                      585179
                      aojiku01 wrote:
                      So how do I enable it. That was the original question I had?
                      You can't enable it because you are using XE Edition. If this is for your testing or learning then install enterprise edition


                      Cheers
                      • 8. Re: How do I enabled the Partitioning feature in SQL Developer?
                        894206
                        Do I need a license to use EE?
                        • 9. Re: How do I enabled the Partitioning feature in SQL Developer?
                          Srini Chavali-Oracle
                          For learning purposes, no license is needed. See the fine print here - http://www.oracle.com/technetwork/licenses/standard-license-152015.html

                          HTH
                          Srini
                          • 10. Re: How do I enabled the Partitioning feature in SQL Developer?
                            585179
                            aojiku01 wrote:
                            Do I need a license to use EE?
                            Before we can answer that you need to provide the purpose of the database.

                            If it's just your personal learning then no license needed (I assume you're in learning process because it's using windows xp sp3 and XE edition)


                            Cheers
                            • 11. Re: How do I enabled the Partitioning feature in SQL Developer?
                              sb92075
                              aojiku01 wrote:
                              So how do I enable it. That was the original question I had?
                              Partitioning only exists for Enterprise Edition
                              • 12. Re: How do I enabled the Partitioning feature in SQL Developer?
                                894206
                                Thanks.

                                I am just learning how to use the database