From oracle-l-bounce@freelists.org Fri Sep 9 20:55:49 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8A1tn2r026414 for ; Fri, 9 Sep 2005 20:55:49 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8A1tkIP026404 for ; Fri, 9 Sep 2005 20:55:46 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B29311E966D; Fri, 9 Sep 2005 20:55:28 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14815-03; Fri, 9 Sep 2005 20:55:28 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 40C2E1E9748; Fri, 9 Sep 2005 20:55:28 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type; b=J1E8ciJB5hrlq1HZyEfEKjk7qiIeQhjAtyDR1dcFyLk+B/BXYmzU3/Pk1+ryVVVegNztmyoN9LdRfrMEngAVM14E7/6/IfS1ZZRDhlDwt+G9ma+s8O8B2mMIhqeXorLla+4xSmfppgpHqIptnt049nxTY8LWJ2eGDuKteGdjRoo= Message-ID: Date: Sat, 10 Sep 2005 09:53:26 +0800 From: Lou Fangxin To: "Oracle-L (E-mail)" Subject: I am going to enable compress table support in MYDUL. Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1491_29595493.1126317206779" X-archive-position: 25260 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: anysql@gmail.com Precedence: normal Reply-To: anysql@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.8 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_1491_29595493.1126317206779 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline but I can only list the valid row entries, but cannot construct the data,= =20 it seems version relative, because in the dump file from "ALTER SYSTEM DUMP= =20 DATAFILE xxx BLOCK xxx" , we can find the followng information. data_block_dump,data header at 0x44b0274 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D tsiz: 0x1f88 hsiz: 0x5be pbl: 0x044b0274 bdba: 0x010000d2 76543210 flag=3D-0------ ntab=3D2 nrow=3D717 frre=3D-1 fsbo=3D0x5be fseo=3D0x1161 avsp=3D0x8f tosp=3D0x8f r0_9ir2=3D0x0 mec_kdbh9ir2=3D0x4 76543210 shcf_kdbh9ir2=3D---------- 76543210 flag_9ir2=3D--R----C fcls_9ir2[3]=3D{ 0 32768 32768 } 0x1c:pti[0] nrow=3D8 offs=3D0 0x20:pti[1] nrow=3D709 offs=3D8 --=20 Welcome, Fangxin.Lou from China Home: http://www.anysql.net/en/ Mydul: http://www.anysql.net/en/mydul.html ------=_Part_1491_29595493.1126317206779 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
 but I can only list the valid row entries, but cannot construct = the data, it seems version relative,  because in the dump file from &q= uot;ALTER SYSTEM DUMP DATAFILE xxx BLOCK xxx" , we can find = the followng information.
 
data_block_dump,data header at 0x44b0274
=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D
tsiz: 0x1f88
hsiz: 0x5be
pbl: 0x044b0274
= bdba: 0x010000d2
     76543210
flag=3D-0------ntab=3D2
nrow=3D717
frre=3D-1
fsbo=3D0x5be
fseo=3D0x1161
avsp=3D0x8f
tosp=3D0x8f
 r0_9ir2=3D0x0
 mec_kdbh9ir2= =3D0x4
           = ;    76543210
 shcf_kdbh9ir2=3D----------
 &= nbsp;         76543210
 fla= g_9ir2=3D--R----C
  fcls_9ir2[3]=3D{ 0 32768 32768 }
0x1c:p= ti[0] nrow=3D8 offs=3D0
0x20:pti[1] nrow=3D709 offs=3D8

--
W= elcome, Fangxin.Lou from China
Home: http://www.anysql.net/en/
Mydul: http://www.anysql.net/en/mydul.html
 
------=_Part_1491_29595493.1126317206779-- -- http://www.freelists.org/webpage/oracle-l