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
Same SQL created a table. It seems to be you installation does not support partitioning.
check select * from v$option;
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.
If you have not then you will have to reinstall the server with partitioning option.
Click Here to Expand Forum to Full Width