Re: View for object_type

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Fri, 7 Sep 2001 11:26:36 +0200
Message-ID: <9na3sg$brm$1@s1.read.news.oleane.net>

"JK Yao" <jkyf0131_at_hotmail.com> a écrit dans le message news: 93f65984.0109070121.6619e9b0_at_posting.google.com...
> dear all,
>
> Does anyone know which view shows which kind of object has which
> object_ID?
> Does any object has columns which show their type, such as table,
> view, package ...etc?
>
> Please share.
> Thanks a lot.
>
> JK

xxx_objects views give you the object_type for an object:

v815> desc dba_objects
 Name

---

 OWNER
 OBJECT_NAME
 SUBOBJECT_NAME
 OBJECT_ID
 DATA_OBJECT_ID
 OBJECT_TYPE
 CREATED
 LAST_DDL_TIME
 TIMESTAMP
 STATUS
 TEMPORARY
 GENERATED
 SECONDARY

--
Have a nice day
Michel

Received on Fri Sep 07 2001 - 04:26:36 CDT