Re: Can a Table be Invalidated?

>ERROR at line 1:
>ORA-02303: cannot drop or replace a type with type or table dependents

>This is 10gR2 and person is still in the recycle bin. If I purge it,
>this goes away.

Verrrry interesting. I think you are demonstrating an inherent problem with recycle bins, as to whether a dependency that _might_ be reconstituted should be a dependency. I suspect this is the-way-it-works as opposed to a bug. But I don't know that much about it.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20050714/images/comicon.pdf