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

hello,

    version 8.0.5. on sun solaris 2.8

    again, though no table, but index still exists.

    however, thank you

--
John
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:970155095.27271.1.nnrp-03.9e984b29_at_news.demon.co.uk...


>

> 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

> >

> >

>

>

>