ALL_OBJECTS

Objects accessible to the user

Columns
   ___________________________
 
   DATA_OBJECT_ID
      Object number of the segment which contains the object
   OBJECT_ID
      Object number of the object
   SUBOBJECT_NAME
      Name of the sub-object (for example, partititon)
   OBJECT_NAME
      Name of the object
   OWNER
      Username of the owner of the object
   CREATED
      Timestamp for the creation of the object
   LAST_DDL_TIME
      Timestamp for the last DDL change (including GRANT and REVOKE) to the object
   TIMESTAMP
      Timestamp for the specification of the object
   STATUS
      Status of the object
   TEMPORARY
      Can the current session only see data that it placed in this object itself?
   GENERATED
      Was the name of this object system generated?
   SECONDARY
      Is this a secondary object created as part of icreate for domain indexes?
   OBJECT_TYPE
      Type of the object

Related Commands:

DBMS_METADATA - Retrieve complete database object definitions

                     ALL_ARGUMENTS    USER_ARGUMENTS

Simon Sheppard
SS64.com