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 )
|