Hmmm ... Oracle deletes all indexes on a tables which is dleted automaticly. I don't not see the sense of an index on a dropped table.
Anyway, dropping the index explicitly is did not helped: > select index_name,table_name from user_indexes * 100: Row not found > drop table testtab * -4004: Unknown table name:TESTTAB > create table testtab (id serial(42),name varchar(200)) * Ok > drop index ix_testtab_name * -4011: Unknown index name:IX_TESTTAB_NAME > create index ix_testtab_name on testtab (name) * -6008: Duplicate index name > drop table testtab * Ok > drop index ix_testtab_name * -4011: Unknown index name:IX_TESTTAB_NAME > create table testtab (id serial(42),name varchar(200)) * Ok > create index ix_testtab_name on testtab (name) * -6008: Duplicate index name > select index_name,table_name from user_indexes INDEX_NAME | TABLE_NAME | ---------------------------------------------------------------------- IX_TESTTAB_NAME | TESTTAB | * Ok Am Montag, 14. Juli 2003 15:49 schrieben Sie: > Without any specific SABDB experience.. > > you need to drop the index in addition to dropping the table. > subsequently the index was still there. > > Regards, > Wolfgang > > > -----Urspr�ngliche Nachricht----- > > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Gesendet: Montag, 14. Juli 2003 15:17 > > An: [EMAIL PROTECTED] > > Betreff: Why this -6008: Duplicate index name ? > > > > > select index_name from user_indexes > > > > INDEX_NAME | > > ----------------------------------- > > IX_TESTTAB_NAME | > > * Ok > > > > > descibe user_indexes > > > > * -3005: Invalid SQL statement > > > > > select index_name,table_name from user_indexes > > > > INDEX_NAME | TABLE_NAME | > > ---------------------------------------------------------------------- > > IX_TESTTAB_NAME | TESTTAB | > > * Ok > > > > > drop table testtab > > > > * Ok > > > > > select index_name,table_name from user_indexes > > > > * 100: Row not found > > > > > create table testtab (id serial(42),name varchar(200)) > > > > * Ok > > > > > create index ix_testtab_name on testtab (name) > > > > * -6008: Duplicate index name > > > > > select index_name,table_name from user_indexes > > > > INDEX_NAME | TABLE_NAME | > > ---------------------------------------------------------------------- > > IX_TESTTAB_NAME | TESTTAB | > > * Ok > > > > Why did I get the error-message after create index ? > > And why is the index created in spite of the error-message ? > > > > _______________________________________________ > > linux.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/linux.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
