|
OWNER
|
VARCHAR2(30)
|
NOT NULL
|
Owner of the object
|
|
OBJECT_NAME
|
VARCHAR2(30)
|
NOT NULL
|
Name of the object
|
|
SUBOBJECT_NAME
|
VARCHAR2(30)
|
|
Name of the subobject (for example, partition)
|
|
OBJECT_ID
|
NUMBER
|
NOT NULL
|
Dictionary object number of the object
|
|
DATA_OBJECT_ID
|
NUMBER
|
|
Dictionary object number of the segment that contains the object
|
|
|
|
Note: OBJECT_ID and DATA_OBJECT_ID display data dictionary metadata. Do not confuse these numbers with the unique 16-byte object identifier (object ID) that Oracle assigns to row objects in object tables in the system.
|
|
OBJECT_TYPE
|
VARCHAR2(15)
|
|
Type of the object (such as TABLE, INDEX)
|
|
CREATED
|
DATE
|
NOT NULL
|
Timestamp for the creation of the object
|
|
LAST_DDL_TIME
|
DATE
|
NOT NULL
|
Timestamp for the last modification of the object resulting from a DDL command (including grants and revokes)
|
|
TIMESTAMP
|
VARCHAR2(20)
|
|
Timestamp for the specification of the object (character data)
|
|
STATUS
|
VARCHAR2(7)
|
|
Status of the object (VALID, INVALID, or N/A)
|
|
TEMPORARY
|
VARCHAR2(1)
|
|
Whether the object is temporary (the current session can see only data that it placed in this object itself)
|
|
GENERATED
|
VARCHAR2(1)
|
|
Was the name of this object system generated? (Y|N)
|
|
SECONDARY
|
VARCHAR2(1)
|
|
Whether this is a secondary object created by the ODCIIndexCreate method of the Oracle9i Data Cartridge (Y | N)
|
