Try out this
Drop index U_SPYADH_2 ;
Regards
Magesh
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 5:50 PM
> Hi Gurus,
>
> I tried to drop unique index using "ALTER TABLE table_name DROP UNIQUE
> (column_n
Suggestion given by Magesh should work for a non-constraint index. If it is
index created by Oracle during the time when you created your unique
constraint you won't be able to get rid of that index until you eliminate
your constraint.
- Original Message -
To: "Multiple recipients of lis
Hi,
Did you try :
SQL> drop index index_name ;
??
HIH,
Antonio Belloni
"CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>@fatcity.com on
30/05/2001 05:50:25
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
If it is an unique index that enforces unique constraint you cannot simply
drop it
You have to drop unique constraint
alter table tablename drop constraint constraintname;
an example follows
SQL> desc qaqa1
NameNull?Type
--- ---
that's not dropping a unique index, that's dropping a column!
to drop an index:
drop index ;
doesn't matter if it is unique or not.
If you are trying to drop a unique constraint, that's different.
first find the name of the unique constraint on that table"
select constraint_name from user_c
Thanks to all who replied. The command "Drop Unique index_name" works.
Regds,
New Bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
