本文转自: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求文件号,块号为: