I am going to enable compress table support in MYDUL.

From: Lou Fangxin <anysql_at_gmail.com>
Date: Sat, 10 Sep 2005 09:53:26 +0800
Message-ID: <ea5907d305090918533b68f63f@mail.gmail.com>

 but I can only list the valid row entries, but cannot construct the data, it seems version relative, because in the dump file from "ALTER SYSTEM DUMP DATAFILE xxx BLOCK xxx" , we can find the followng information.  data_block_dump,data header at 0x44b0274

---

tsiz: 0x1f88
hsiz: 0x5be
pbl: 0x044b0274
bdba: 0x010000d2
76543210

flag=-0------
ntab=2
nrow=717
frre=-1
fsbo=0x5be
fseo=0x1161
avsp=0x8f
tosp=0x8f

r0_9ir2=0x0
mec_kdbh9ir2=0x4
76543210
shcf_kdbh9ir2=----------
76543210
flag_9ir2=--R----C
fcls_9ir2[3]={ 0 32768 32768 }
0x1c:pti[0] nrow=8 offs=0
0x20:pti[1] nrow=709 offs=8

--

Welcome, Fangxin.Lou from China
Home: http://www.anysql.net/en/
Mydul: http://www.anysql.net/en/mydul.html

--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 09 2005 - 20:55:49 CDT