I feel Compress=y is better in most cases. If you have MINEXTENTS
parameter set for your tables, then COMPRESS=Y may create problems while
importing. Compress=y will create an initial extent that is large enough
to accommodate all the records in a table. Because of MINEXTENS parameter,
It will allocate MINEXTENTS number of extents with the Modified Initial
extent value.
--
Vijaya Kumar Vardhineni
Certified Oracle DBA, EDS
Plano, TX
Priya Tantry <tantry_at_cc.uq.oz.au> wrote in article
<32DB30E1.41C67EA6_at_cc.uq.oz.au>...
> I am trying to do a full export import of the database because te
> tablespaces are highly fragmented
>
> Is it a good idea to have compress=N set or leave the default compress=Y
> while doing a full export / import
>
>
> Thanks
> Priya Tantry
> University of Queensland
>
Received on Tue Jan 14 1997 - 00:00:00 CST
