根据rowid查找数据文件号,数据块号

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;
请使用浏览器的分享功能分享到微信等