Hawkeye-X
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Nov-13-03 06:10 PM
Original message |
Oracle gurus: Index question |
|
I'm trying to create a index, and I get this error:
SQL> CREATE INDEX BOOKIND ON BOOK(TITLE); CREATE INDEX BOOKIND ON BOOK(TITLE) * ERROR at line 1: ORA-01408: such column list already indexed
If it is already indexed, how can I locate that index and drop it?
Hawkeye-X
|
TrogL
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Nov-13-03 06:25 PM
Response to Original message |
|
select tname, colnames, iname, creator, icreator, indextype from indexes;
|
Hawkeye-X
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Nov-13-03 06:29 PM
Response to Reply #1 |
|
SQL> select tname, colnames, iname, creator, icreator, indextype from indexes; select tname, colnames, iname, creator, icreator, indextype from indexes * ERROR at line 1: ORA-00942: table or view does not exist
|
TrogL
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Nov-13-03 06:42 PM
Response to Reply #2 |
|
drop index (indexname) on (tablename);
|
Hawkeye-X
(1000+ posts)
Send PM |
Profile |
Ignore
|
Thu Nov-13-03 06:40 PM
Response to Original message |
Undemcided
(225 posts)
Send PM |
Profile |
Ignore
|
Thu Nov-13-03 08:17 PM
Response to Original message |
|
My guess is that this is a primary index created by oracle itself.
|
DU
AdBot (1000+ posts) |
Fri Apr 19th 2024, 09:57 PM
Response to Original message |