本文轉自:http://www.xifenfei.com/1524.html
說明事宜:
1、tailchk=Lower order two bytes of SCN Base(bas_kcbh) + Block Type(type_kcbh) + SCN Seq(seq_kcbh)
2、塊的scn為:scn=wrp_kcbh+bas_kcbh
求scn語句:select to_char(to_number(‘scn’,'xxxxxxxxxx’),’999999999999′) from dual;
3、dba求檔案号,塊号為: