通過rowid查詢行所在的block,FILE OBJECT

renjixinchina發表於2014-03-05
SELECT rowid,
       DBMS_ROWID.Rowid_object(ROWID) "OBJECT",
       DBMS_ROWID.Rowid_relative_fno(ROWID) "FILE",
       DBMS_ROWID.Rowid_block_number(ROWID) "BLOCK",
       DBMS_ROWID.Rowid_row_number(ROWID) "ROW"
  FROM tablename

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15747463/viewspace-1101758/,如需轉載,請註明出處,否則將追究法律責任。

相關文章