Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_OBJECTS

Objects owned by the user

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

Related Commands:




Back to the Top

Simon Sheppard
SS64.com