This content has been marked as final.
Show 12 replies
-
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
http://download.oracle.com/docs/cd/E11882_01/server.112/e25513/dynviews_2084.htm#REFRN30167SQL> select * from v$OPTION;
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 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 -
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; -
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 -
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:
The partition is not enabled in your database. and since you're using XE edition this feature will not be available
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
Cheers -
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? -
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:
You can't enable it because you are using XE Edition. If this is for your testing or learning then install enterprise edition
So how do I enable it. That was the original question I had?
Cheers -
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? -
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 -
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:
Before we can answer that you need to provide the purpose of the database.
Do I need a license to use EE?
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 Nov 21, 2011 1:21 AM (in response to 894206)aojiku01 wrote:
Partitioning only exists for Enterprise Edition
So how do I enable it. That was the original question I had? -
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