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