oracle转储

oracle  根据rowid得到行所在的对象号,数据文件号,块号,行编号。 

DBMS_ROWID.ROWID_OBJECT(ROWID) OBJECT_ID,

    DBMS_ROWID.ROWID_RELATIVE_FNO(ROWID) FILE_ID,

    DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID) BLOCK_ID,

    DBMS_ROWID.ROWID_ROW_NUMBER(ROWID) NUM,

posted on 2016-02-09 15:30  wangxingc  阅读(246)  评论(0编辑  收藏  举报

导航