select rowid from test_block_num where rownum=1;
select DBMS_ROWID.ROWID_OBJECT('&rowid') data_object_id#,
DBMS_ROWID.ROWID_RELATIVE_FNO('&rowid') rfile#,
DBMS_ROWID.ROWID_BLOCK_NUMBER('&rowid') block#,
DBMS_ROWID.ROWID_ROW_NUMBER('&rowid') row#
from dual;
& 多次
select rowid from test_block_num where rownum=1;
select DBMS_ROWID.ROWID_OBJECT('&&rowid') data_object_id#,
DBMS_ROWID.ROWID_RELATIVE_FNO('&&rowid') rfile#,
DBMS_ROWID.ROWID_BLOCK_NUMBER('&&rowid') block#,
DBMS_ROWID.ROWID_ROW_NUMBER('&&rowid') row#
from dual;
&& 一次
col owner format a10
col object_name format a20
select owner, object_name from dba_objects where object_id=&data_object_id;
col file_name format a40
col tablespace_name format a30
select file_name, tablespace_name from dba_data_files where file_id=&rfile;