ORACLE object_id and data_object_id

Both object_id and data_object_id are unique identities of objects.

OBJECT_ID is the logical identity of an object

DATA_OBJECT_ID is the physical identity of the object

For objects that do not have physical storage, data_object_id is empty. For example: (procedure,function,package,data type,db link,mv definition, view definition, temp table, partition table definition, etc.)

The object_id and data_object_id are equal when the table is first created, but data_object_id will change if the table passes a move or truncate.

ORACLE object_id and data_object_id