declare
ridtyp number;
objnum number;
relfno number;
blno number;
rowno number;
rid rowid;
begin
select rowid into rid from test where id=1;
dbms_rowid.rowid_info(rid, ridtyp,objnum,relfno,blno,rowno );
dbms_output.put_line('Row Type:' || to_char(ridtyp));
dbms_output.put_line('objnum:' || to_char(objnum));
dbms_output.put_line('relfno:' || to_char(relfno));

dbms_output.put_line('blno:' || to_char(blno));
dbms_output.put_line('rowno :' || to_char(rowno ));
end;

根據rowid查詢資料檔案號，資料塊號

相關文章