Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle9.2: Data segment compression bug
Also I think the installation notes for 9.2 also have a section on determining which segments are compressed - basically quoting a fragment of code similar to the one that Connor has pointed out. (Possibly it's in the white-paper that another poster has already mentioned).
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) ____USA__________November 19/21 (Dallas) ____England______January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Connor McDonald wrote in message <3DD7D121.51D4_at_yahoo.com>...Received on Sun Nov 17 2002 - 12:49:25 CST
>
>Its not there in xxx_TABLES (once again a bug) but if you look at the
>definition for xxx_TAB_PARTITIONS (where it IS there), you can see
that
>its just an attribute within SEG$
>
>hth
>connor
>--
>==============================
>Connor McDonald