Re: Q: How to get rid of undefined objects?

Ms. D.H. Harvey wrote:
>
> ,Anonymous Developer <orakcle_at_yahoo.com> wrote:
> : I want to get rid of an object of type 'UNDEFINED'.
> : How can I get rid of it?
> : Which DROP command (or any other relevant command) should I use?
>
> Believe UNDEFINED object type internally used type. If you 'get
> rid of it' might find yourself in trouble.
>
> Helen

If you look at the definition for DBA_OBJECTS (or one of its underlying components) you'll see a massive decode for all the object types. If its not one of them, then either:

• its a bug
• its used internally by Oracle (for example, _NEXT_OBJECT)

You'd need to check with Oracle upon which is relevant to you

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."