Re: object_id vs data_object_id in user_objects

The data object id is assigned at creation time and does not change unless the object is dropped and recreated. The data_object_id is also assigned at creation time but over time the segment used to store the object can be changed.

Observe
UT1 > select object_id, data_object_id from dba_objects   2 where object_name = 'MARKTEST_IDX1';

 OBJECT_ID DATA_OBJECT_ID
---------- --------------

     31698 31699

UT1 > alter index marktest_idx1 rebuild;

Index altered.

UT1 > select object_id, data_object_id from dba_objects   2 where object_name = 'MARKTEST_IDX1';

 OBJECT_ID DATA_OBJECT_ID
---------- --------------

     31698 31980

The data_object_id changed to reflect the new segment used to house the index.

run this query
select owner, object_name, object_type, object_id, data_object_id from dba_objects
where object_id <> data_object_id

And take a look at what turns up.

HTH -- Mark D Powell -- Received on Fri Mar 04 2005 - 16:03:56 CET