Home » RDBMS Server » Server Administration » convert global index to local index (Oracle 10g)
convert global index to local index [message #513057] Thu, 23 June 2011 07:49 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 13962
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
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 Go to previous message
cookiemonster
Messages: 13962
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 27 01:34:06 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.