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 the Oracle Database assigns to row objects in object tables in the system. |
OBJECT_TYPE |
VARCHAR2(19) |
|
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 statement (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) |
|
Indicates whether the name of this object was system generated (Y) or not (N) |
SECONDARY |
VARCHAR2(1) |
|
Whether this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y | N) |
