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
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

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: 63919
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to recreate it.

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

Current Time: Tue Oct 25 02:29:42 CDT 2016

Total time taken to generate the page: 0.08231 seconds