Partition Table

When I create a partition table in my oracle 9i database, the following error occurs:

create table a (deptno number, deptname varchar2(1))
partition by range (deptno)
(partition ab values less than (1))

*
ERROR at line 1:
ORA-00439: feature not enabled: Partitioning


What happened?

Hi

Same SQL created a table. It seems to be you installation does not support partitioning.

check select * from v$option;


Thomas

Check if you have installed partitioning with the following query

select * from v$option where parameter = 'Partitioning';
You should be able to see the following if partitioning is available.
PARAMETER VALUE
------------- -------------------

Partitioning TRUE

If you have not then you will have to reinstall the server with partitioning option.

Sam:)

Quote:

---

Originally posted by samx18
If you have not then you will have to reinstall the server with partitioning option.
Sam:)

---

No need to reinstall the whole server. just install the partition option.