OraFAQ Forum: Server Administration » Partition Table-needed to set any Initialization Parameters?

Home » RDBMS Server » Server Administration » Partition Table-needed to set any Initialization Parameters?

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

Partition Table-needed to set any Initialization Parameters? [message #146957]

Mon, 14 November 2005 20:48

nisaluck
Messages: 4
Registered: November 2005

Junior Member

I've tried to create a partition table on Oracle10.2g, a Standard Edition. I start the Oracle installer again and check Oracle Partitioning. Then shutdown and re-startup db. I can't still create a partition table. Need I set any other environments, such as Initialization Parameters...???

Report message to a moderator

Re: Partition Table-needed to set any Initialization Parameters? [message #147002 is a reply to message #146957]

Tue, 15 November 2005 04:00

Frank Naude
Messages: 4590
Registered: April 1998

Senior Member

There is no initialization parameter to enable partitioning. However, it's only available with Oracle Enterprise Edition - not with Standard Edition.

Best regards.

Frank

Report message to a moderator

Re: Partition Table-needed to set any Initialization Parameters? [message #147132 is a reply to message #146957]

Tue, 15 November 2005 20:21

nisaluck
Messages: 4
Registered: November 2005

Junior Member

Thanks so much, Frank.
When I created a partition table, I got ORA-00439: feature not enabled:Partitioning.
These occurs on Standard Edition with additional install "the Partition feature" (After Standard Edt installing, I call OUI again to setup the partitioning feature)
I would like to use Standard Edition with the partitioning. Can I??

Report message to a moderator

Re: Partition Table-needed to set any Initialization Parameters? [message #147330 is a reply to message #147132]

Thu, 17 November 2005 04:29

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

As Frank says

Quote:

it's only available with Oracle Enterprise Edition - not with Standard Edition.

Jim

Report message to a moderator

Re: Partition Table-needed to set any Initialization Parameters? [message #147358 is a reply to message #147330]

Thu, 17 November 2005 06:42

lazycat
Messages: 57
Registered: November 2005

Member

trrible
10g can create Partitioned Tables without any set

Report message to a moderator

Re: Partition Table-needed to set any Initialization Parameters? [message #147362 is a reply to message #147358]

Thu, 17 November 2005 06:48

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Quote:

10g can create Partitioned Tables without any set

Are you saying that Oracle 10g can creat partitioned tables in standard edition? or am I misunderstanding your post?

Report message to a moderator

Re: Partition Table-needed to set any Initialization Parameters? [message #147364 is a reply to message #147362]

Thu, 17 November 2005 06:52

lazycat
Messages: 57
Registered: November 2005

Member

Report message to a moderator

Re: Partition Table-needed to set any Initialization Parameters? [message #149026 is a reply to message #146957]

Tue, 29 November 2005 13:59

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

In simple English

1. Partitioned table can ONLY be created if you have installed Enterprise Edition of Oracle. Not available in Standard Edition.
2. There are NO setttings to create partitioned tables (just like you do not need any settings to create a table).

--
Sanjay

Report message to a moderator

Previous Topic:	How to monitor view usage ?
Next Topic:	sql script on crontab

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 16:49:03 CST 2025