when table is dropped, index is not dropping also ????

hello,

    during a refresh process, a table is dropped, then recreated via a view using dbms_sql to build statements.

    ora-00955 object already exists error occur, throwing refresh.

    i can catch the error in an error exception handler, but

• is it not TRUE that when a table is dropped, ALL indexes drop also ----

    error is occuring due to pre-existing index that should have been dropped with the table

    odd?

    any information will be much appreciated.

--

John Received on Thu Sep 28 2000 - 10:27:04 CDT