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

You don't say which version of Oracle you are using.

dbms_sql execute DDL at the parse call. I would be inclined to suspect that you are getting this error because the create statement is being executed twice, possibly on the parse and on the execute (which would be a bug in dbms_sql).

Try putting an exception clause around the parse and around the execute and seeing where the trap occurs.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

John A. Pearson wrote in message ...


>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

>

>