Partition feature [message #138490] |
Thu, 22 September 2005 04:48 |
rebeccaz
Messages: 18 Registered: August 2005
|
Junior Member |
|
|
Hi,
Does anyone know how I enable the partition feature for Oracle 9i Enterprise version?
Regards,
Rebecca
|
|
|
|
Re: Partition feature [message #141195 is a reply to message #138490] |
Fri, 07 October 2005 08:07 |
wushu_kid
Messages: 7 Registered: October 2005
|
Junior Member |
|
|
I presume you mean table partitioning.
It is an addtional option and you need to install it. It is also an extra chargeable option.. $$$$$ ;-(
Then it is all up to you to create partition tables.. bla bla
SQL> create table tb (
key int,
x int
)
partition by range (key)
(
partition p_oneval values less than (10),
partition p_distinct values less than (99999999)
)
/
|
|
|