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

no luck,

same error....

i actually dropped the table by hand and the index stayed..

i'm now thinking that i might have something not so good here......

anyone seen this before and what is a possible solution?

i 'm going to start dropping the indexes, in the mean time, explicitly......

thank you

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


>

> 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

> >> >

> >> >

> >>

> >>

> >>

> >

> >

>

>