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? |
SECONDARY |
VARCHAR2(1) |
|
Whether this is a secondary object created by the ODCIIndexCreate method of the Oracle8i Data Cartridge (Y | N) |