Home » RDBMS Server » Performance Tuning » Partition feature
icon5.gif  Partition feature [message #138490] Thu, 22 September 2005 04:48 Go to next message
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 #138580 is a reply to message #138490] Thu, 22 September 2005 09:28 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/toc.htm
Re: Partition feature [message #141195 is a reply to message #138490] Fri, 07 October 2005 08:07 Go to previous message
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)
)
/
Previous Topic: Tuning SQL
Next Topic: max memory of oracle process
Goto Forum:
  


Current Time: Sat Nov 23 16:38:30 CST 2024