Oracle-L: Oracle 9.2.0.3 Compressed Tables

From: <John.Larocque_at_cexp.com>
Date: Thu, 04 Sep 2003 13:29:26 -0800
Message-ID: <F001.005CECF6.20030904132926@fatcity.com>

Two questions to anyone that has worked with compressed tables.

Have any work arounds been discovered to alter tables and say add columns after a partition has been compressed and then uncompressed?
In looking at a block dump of a compressed 9.2 block you can see the following pieces of information after the Tosp (total available space when all TXs commit): r0_9ir2=0x0 mec_kdbh9ir2=0x2b r1_9ir2=0x0 76543210 flag_9ir2=------OC fcls_9ir2[20]={ 0 32768 32768 32768 32768 32768 32768 32768 32768 32768 32768 32768 32768 32768 32768 32768 32768 32 768 32768 32768 } perm_9ir2[38]={ 30 26 12 16 0 25 27 28 17 31 32 23 13 33 34 19 1 35 24 21 22 36 37 29 2 14 3 18 4 5 6 7 8 9 10 15 11 20 } Are these symbol table entries or something else?

Thanks

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: John.Larocque_at_cexp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Sep 04 2003 - 16:29:26 CDT