Saturday, 25 June 2016

Feature Enable


Just illustration for fun .....
It in fact violates the license.

This Document is only for study purpose, don't use it in production Server, It's a crime for without licencing use the feature.

All Features are enable in EE (Enterprise Edition).

Actually some features not enabled, if you are using Oracle SE (Standard Edition). Follow the point to see the feature is enable or not in  (SE) .

--In my case

1. Login as sys

# List of all features.
select * from v$option;

# See the Partition feature is enabled or not. In my case (SE)
select * from v$option where parameter='Partitioning';

2. Create Partition table.

CREATE TABLE invoices
(invoice_no    NUMBER NOT NULL,
invoice_date  DATE   NOT NULL,
comments      VARCHAR2(500))
PARTITION BY HASH (invoice_no)
PARTITIONS 4
STORE IN (users, users, users, users);

3. Getting error: 

ORA-00439: feature not enabled: Partitioning while trying to create table with partition.

4. I have solution for linux and unix systems here:

shutdown database
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk part_on
$ make -f ins_rdbms.mk ioracle


# If Using Windows then below the step:
  if you indeed have the Oracle Enterprise Edition AND the license option for partitioning, you need to enable it through the OUI (Oracle Universal Installer).

  Shutdown the database, open the OUI from your Oracle Home, and install "Partitioning".

5. startup 


6. Verify it.
select * from v$option where parameter='Partitioning';

7. Create Partition table.

CREATE TABLE invoices
(invoice_no    NUMBER NOT NULL,
invoice_date  DATE   NOT NULL,
comments      VARCHAR2(500))
PARTITION BY HASH (invoice_no)
PARTITIONS 4
STORE IN (users, users, users, users);

Table created.

No comments: