Re: Export - Import question

Yes, in most situations compress=y will be good for de-fragmentation of tablespaces. But be careful if you have some very large tables of which initial extent (after compressed) may be larger than what you can allocate in a single data file when you do the import. In that way you will get an error message since an extent cannot span multiple files.

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
Received on Thu Jan 16 1997 - 00:00:00 CST