Re: Oracle Table Compression.
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: fuadar@xxxxxxxxx
- Date: Tue, 21 Sep 2004 21:03:16 -0400
Fuad,
9.2.0.6?
I've seen specific components with that version listed, but heard
nothing yet as to it being released as a comprehensive OUI-driven
patchset.
Any idea as to when this will be released?
thanks,
Paul
On Tue, 21 Sep 2004 06:32:23 -0700 (PDT), Fuad Arshad <fuadar@xxxxxxxxx> wrote:
> Oracle does have a one off patch for the bug in which you cannot alter a
> table after compressing it and its not included in 9.2.0.5 not will it be
> included in 9.2.0.6 seperate one offs need to be backported to each patch
> set.
> the bug number is 2421054
>
>
>
> rjamya <rjamya@xxxxxxxxx> wrote:
> you can compress tables, and associated indexes as well. Remember that
> in some versions of 92xx, you can't do direct exports, they throw
> ora-600. also you cannot alter columns using ddl when compressed, so
> you need to be able to un-compress if table needs to be altered.
>
> Otherwise it may be a good thing, as always all expressed opinions are
> invalid without you doing tests to satisfy your needs in your
> environment.
>
> Raj
>
> On Tue, 21 Sep 2004 09:41:52 +0100, Mirza Shahed wrote:
> > Thank you everyone,
> >
> > What I am really looking for problems and solutions normally identified and
> > resolved with table compression.
> >
> > I have read about this, I have also tried on our development database.
> >
> > I have noticed that secondary index goes un-usable when I compress a table.
> > Does this means I have to compress secondary index as well, or should I drop
> > secondary index as it is not required anymore?
> >
> > TIA,
> > Shahed.
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
