OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Partition feature

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Partition feature [message #138580 is a reply to message #138490]

Thu, 22 September 2005 09:28

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

Report message to a moderator

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)
)
/

Report message to a moderator

Previous Topic:	Tuning SQL
Next Topic:	max memory of oracle process

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 17:18:20 CDT 2025