EXA_DBA_OBJECTS

This system table describes all of the database objects. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column Name Description
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
CREATED Timestamp of when the object was created
LAST_COMMIT Last time the object was changed in the DB
OWNER Owner of the object
OBJECT_ID Unique ID of the object
ROOT_NAME Name of the containing object
ROOT_TYPE Type of the containing object
ROOT_ID ID of the containing object
OBJECT_IS_VIRTUAL States whether this is a virtual object
OBJECT_COMMENT Comment on the object