| create unique index [message #271711] |
Tue, 02 October 2007 11:06  |
caprikar
Messages: 226
Registered: March 2007
|
Senior Member |
|
|
Hi,
I'm trying to create a unique index but its failing with:
ORA-00955: name is already used by an existing object
But when i query:
SQL> SELECT INDEX_NAME,TABLE_OWNER,TABLE_NAME,UNIQUENESS FROM USER_INDEXES WHERE TABLE_NAME='COUNT_REF';
it returns with no rows selected.
Can some one through some light what could be the issue?
Thanks,
GK
|
|
|
|
|
|
| Re: create unique index [message #271731 is a reply to message #271715] |
Tue, 02 October 2007 13:03  |
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
|
Senior Member |
|
|
| Michel Cadot wrote on Tue, 02 October 2007 11:15 | "Object" does not mean "index", there are many types of object.
|
Which is why it's generally a good practice to suffix your objects. _IDX for index _SEQ for Sequence _V for view _PRC for Procedure etc etc.
|
|
|
|
| Re: create unique index [message #271735 is a reply to message #271711] |
Tue, 02 October 2007 13:16 |
Bill B
Messages: 1971
Registered: December 2004
|
Senior Member |
|
|
select object_type
from user_objects
where object_name='COUNT_REF';
Personally I user _U1 for unique indexes, _I1 for indexes, _PK for primary key, _V for views and _S for sequences.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
