col blk for 99999
col fno for 99
col rnum for 999
select dbms_rowid.rowid_block_number(rowid) blk,
dbms_rowid.rowid_relative_fno(rowid) fno,
dbms_rowid.rowid_row_number(rowid) rnum,
'CHAR$',part,version,piece#,length
from idl_char$
where obj#=(select obj# from obj$ where name = 'AA')
union
select dbms_rowid.rowid_block_number(rowid) blk,
dbms_rowid.rowid_relative_fno(rowid) fno,
dbms_rowid.rowid_row_number(rowid) rnum,
'UB2$',part,version,piece#,length
from idl_ub2$
where obj#=(select obj# from obj$ where name = 'AA')
union
select dbms_rowid.rowid_block_number(rowid) blk,
dbms_rowid.rowid_relative_fno(rowid) fno,
dbms_rowid.rowid_row_number(rowid) rnum,
'ub1$',part,version,piece#,length
from idl_ub1$
where obj#=(select obj# from obj$ where name = 'AA')
union
select dbms_rowid.rowid_block_number(rowid) blk,
dbms_rowid.rowid_relative_fno(rowid) fno,
dbms_rowid.rowid_row_number(rowid) rnum,
'sb4$',part,version,piece#,length
from idl_sb4$
where obj#=(select obj# from obj$ where name = 'AA')
order by part,piece#
/