dbms_rowid.create_rowid 中的object_number 问题

Question

   在用dbms_rowid.create_rowid生成指定file#,block#的rowid时 需要知道这个对象的object_id(create_rowid里的object_number参数） 但分区表对象有N个object_id  怎么确定是哪个？

Answer 1

select rownum,
 DBMS_ROWID.ROWID_CREATE(1,o.data_object_id,e.RELATIVE_FNO,e.BLOCK_ID,0),
 DBMS_ROWID.ROWID_CREATE(1,o.data_object_id,e.RELATIVE_FNO,e.BLOCK_ID+e.BLOCKS-1,10000),
 0
 from dba_extents e,dba_objects o
 where e.segment_name=upper('base_table')
 and e.owner='CSDN'
 AND o.object_name = upper('base_table')
 AND o.owner='CSDN';