type

Type of DICT object; join on dict_obj_types to obtain the name

id

Object identifier; for Disk Data undo log files and data files, this is the same as the value shown in the LOGFILE_GROUP_NUMBER column of the Information Schema FILES table

version

Object version

state

Object state

parent_obj_type

Parent object's type (a dict_obj_types type ID); 0 indicates that the object has no parent

parent_obj_id

Parent object ID (such as a base table); 0 indicates that the object has no parent

fq_name

Fully qualified object name; for a table, this has the form database_name/def/table_name, for a primary key, the form is sys/def/table_id/PRIMARY, and for a unique key it is sys/def/table_id/uk_name$unique