OraFAQ Forum: Server Administration » convert global index to local index

Home » RDBMS Server » Server Administration » convert global index to local index (Oracle 10g)

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

convert global index to local index [message #513057]

Thu, 23 June 2011 07:49

shamsh_pervaiz
Messages: 22
Registered: September 2005
Location: bangalore

Junior Member

Hi All,

I have a global index and I want to convert it to local index.
Is there a way to recreate local index with out dropping the global index.

I can create a local index first and then drop the global index. But is there a way to create it with out dropping the global index, just convert it.

You suggestions will be appreciated.

Thanks
SP

Report message to a moderator

Re: convert global index to local index [message #513059 is a reply to message #513057]

Thu, 23 June 2011 07:52

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No way.

Regards
Michel

Report message to a moderator

Re: convert global index to local index [message #513061 is a reply to message #513059]

Thu, 23 June 2011 07:54

shamsh_pervaiz
Messages: 22
Registered: September 2005
Location: bangalore

Junior Member

Any other suggestions to do create a local index as PK replacing the global index PK.

Thanks
SP

Report message to a moderator

Re: convert global index to local index [message #513064 is a reply to message #513061]

Thu, 23 June 2011 08:03

cookiemonster
Messages: 13921
Registered: September 2008
Location: Rainy Manchester

Senior Member

Nope. Create the local, drop the global.

Report message to a moderator

Re: convert global index to local index [message #513068 is a reply to message #513064]

Thu, 23 June 2011 08:06

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Cookiemonster, OP said "any other suggestion" so please give another solution.

Regards
Michel

Report message to a moderator

Re: convert global index to local index [message #513078 is a reply to message #513068]

Thu, 23 June 2011 08:21

cookiemonster
Messages: 13921
Registered: September 2008
Location: Rainy Manchester

Senior Member

Can't find a smiley for sticking my tongue out at you.

Report message to a moderator

Previous Topic:	Changing web IP address(2 Merged)
Next Topic:	ORA-01555

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 01:40:32 CDT 2024