OraFAQ Forum: Server Administration » Disable partition feature

Home » RDBMS Server » Server Administration » Disable partition feature (Oracle 10.2.0.1.0,windows)

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

Disable partition feature [message #541814]

Thu, 02 February 2012 07:42

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

I am using Oracle 10g enterprise edition .

Currently, Partition is enabled in my database.I want to disable it.

SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Partitioning';

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Partitioning
TRUE

Please tell me the steps to disable the partition feature.

Thanks

Report message to a moderator

Re: Disable partition feature [message #541815 is a reply to message #541814]

Thu, 02 February 2012 08:05

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

On windows, unless there is something new, you have to reinstall Oracle unchecking the option.
This does not impact the existing databases.

Regards
Michel

Report message to a moderator

Re: Disable partition feature [message #542164 is a reply to message #541815]

Sun, 05 February 2012 10:31

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Michel,

Thank you for your instruction.

I dont find the option for unchecking partition while reinstalling oracle software. Could you
tell me the exact step i can find the page for unchecking partition.

Regards,

Report message to a moderator

Re: Disable partition feature [message #542166 is a reply to message #542164]

Sun, 05 February 2012 10:40

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I should be more specific.
You have to deinstall then reinstall; the option will be there among installation options under Entreprise Edition one, it is checked by default (iirc).

Regards
Michel

Report message to a moderator

Previous Topic:	Taking partitions off line in tables
Next Topic:	how can i delete a database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 02:31:09 CST 2024