Home » SQL & PL/SQL » SQL & PL/SQL » How to alter index (Oracle9i ,Windows)
How to alter index [message #277444] Tue, 30 October 2007 02:50 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi all,

How to modify index non unique index from unique index...

For example

i created unique index

create unique index in_id on sample(id);

now i want to modify this unique index to non unique index

Thanks
Michael
Re: How to alter index [message #277445 is a reply to message #277444] Tue, 30 October 2007 02:52 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You have to recreate it.

Regards
Michel
Previous Topic: Can i pass collection into a ref cursor?
Next Topic: Updating records of a collection
Goto Forum:
  


Current Time: Sun Feb 16 00:38:05 CST 2025