Re: Export - Import question

Priya Tantry wrote:
>
> 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

By all means you have to do export with compress=Y if you want to reduce tablespace fragmentation, otherwise you'll end up with same extents for every segment as you have now.

Compress will put each segment into one extent (compress current extents into one) which is also desired for the better performance.

Regards, Jure

-- 
 ===============================================================
 ! Jurij Modic                            Republic of Slovenia !
 !  tel: +386 61 178 55 14                Ministry of Finance  !
 !  fax: +386 61  21 45 84                Zupanciceva 3        !
 !  e-mail: jurij.modic_at_mf.sigov.mail.si  Ljubljana 1000       !
 ===============================================================