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

Is it possible that an index of the name you want has been created on another table ?

It shouldn't be possible for an index to exist without its table.

--

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

John A. Pearson wrote in message ...


>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

>> >

>> >

>>

>>

>>

>

>