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

How do I enabled the Partitioning feature in SQL Developer?

894206 Nov 20, 2011 11:07 PM

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 Nov 20, 2011 11:37 PM (in response to 894206)
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
Like Show 0 Likes(0)

Actions
2. Re: How do I enabled the Partitioning feature in SQL Developer?

894206 Nov 20, 2011 11:39 PM (in response to Srini Chavali-Oracle)

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
Like Show 0 Likes(0)

Actions
3. Re: How do I enabled the Partitioning feature in SQL Developer?

sb92075 Nov 20, 2011 11:58 PM (in response to 894206)

post results from following SQL

SELECT * FROM V$VERSION;
Like Show 0 Likes(0)

Actions
4. Re: How do I enabled the Partitioning feature in SQL Developer?

894206 Nov 21, 2011 12:10 AM (in response to sb92075)

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
Like Show 0 Likes(0)

Actions
5. Re: How do I enabled the Partitioning feature in SQL Developer?

585179 Nov 21, 2011 12:22 AM (in response to 894206)

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
Like Show 0 Likes(0)

Actions
6. Re: How do I enabled the Partitioning feature in SQL Developer?

894206 Nov 21, 2011 12:22 AM (in response to 585179)

So how do I enable it. That was the original question I had?
Like Show 0 Likes(0)

Actions
7. Re: How do I enabled the Partitioning feature in SQL Developer?

585179 Nov 21, 2011 12:24 AM (in response to 894206)

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
Like Show 0 Likes(0)

Actions
8. Re: How do I enabled the Partitioning feature in SQL Developer?

894206 Nov 21, 2011 12:47 AM (in response to 585179)

Do I need a license to use EE?
Like Show 0 Likes(0)

Actions
9. Re: How do I enabled the Partitioning feature in SQL Developer?

Srini Chavali-Oracle Nov 21, 2011 12:51 AM (in response to 894206)

For learning purposes, no license is needed. See the fine print here - http://www.oracle.com/technetwork/licenses/standard-license-152015.html

HTH
Srini
Like Show 0 Likes(0)

Actions
10. Re: How do I enabled the Partitioning feature in SQL Developer?

585179 Nov 21, 2011 1:11 AM (in response to 894206)

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
Like Show 0 Likes(0)

Actions
11. Re: How do I enabled the Partitioning feature in SQL Developer?

sb92075 Nov 21, 2011 1:21 AM (in response to 894206)

aojiku01 wrote:
So how do I enable it. That was the original question I had?
Partitioning only exists for Enterprise Edition
Like Show 0 Likes(0)

Actions
12. Re: How do I enabled the Partitioning feature in SQL Developer?

894206 Nov 21, 2011 1:21 AM (in response to Srini Chavali-Oracle)

Thanks.

I am just learning how to use the database
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.