CODEWITHSUNDEEP
oracle-databasepartitioning
lucifer
lucifer

Reputation: 2327

how to enable partitioning option true after installing the Oracle?

I have installed oracle 10G XE but in the time of installation i may have not enabled the partion option.now when i am running the command 

select * from v$option where parameter = 'Partitioning'; its showing false ..

when i tried to run this script

   CREATE TABLE products
 (partno NUMBER,
  description VARCHAR2 (60))
PARTITION BY HASH (partno)
PARTITIONS 4
STORE IN (tab1, tab2, tab3, tab4);

it shows that

ORA-00439: feature not enabled: Partitioning

i have important tables there if i delete the database then i will have to face problem.

can i enable portioning option after installing??or i have to re install the oracle??please help.

Upvotes: 1

Views: 26248

Answers (1)

Ostap
Ostap

Reputation: 11

Please take a look here . Just launch Oracle Universal Installer (OUI) from folder where it installed and install Partitioning component for your database.

Upvotes: 0

Related Questions