| Partitioning of tables [message #374238] |
Fri, 01 June 2001 00:05  |
GIRIDHAR KODAKALLA
Messages: 92
Registered: May 2001
|
Member |
|
|
Hai friends,
I have some problem which creating a table with partitions. Can any one help me on this???
The error is as shown :
SQL> l
1 create table kgr (name varchar2(100),num number)
2 partition by range (num)
3 (partition p1 values less than (10),
4 partition p2 values less than (20),
5* partition p2 values less than (MAXVALUE))
SQL> /
create table kgr (name varchar2(100),num number)
*
ERROR at line 1:
ORA-00439: feature not enabled: Partitioning
Thanks in Advance.
Giridhar Kodakalla
|
|
|
|
| Re: Partitioning of tables [message #374249 is a reply to message #374238] |
Fri, 01 June 2001 23:01  |
Sarada
Messages: 27
Registered: April 2001
|
Junior Member |
|
|
You have to specifically enable the Oracle Partition option. Check with your DBA and ask him/her to enable the Partition option. If you are the DBA, then let me know I will give you the procedure to enable it. BTW, What version of ORacle you are using on which platform.
Orashark.
|
|
|
|
| Re: Partitioning of tables [message #374250 is a reply to message #374249] |
Sat, 02 June 2001 02:10 |
GIRIDHAR KODAKALLA
Messages: 92
Registered: May 2001
|
Member |
|
|
Hai Orashark ,
Thanks for ur reply. I contacted my DBA.
He told me that ours is not Enterprised Edition and hence we cannot have the Parititoning option enabled. You told me that you will send some script for that. So if i am not working on enterprised edition, cant i enable that feature???
Regards,
Giridhar Kodakalla
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
