Re: Export - Import question

From: Strategic Data Systems <sds_at_dataplusnet.com>
Date: 1997/01/16
Message-ID: <5blafq$742$1@news.inc.net>#1/1

In article <32DB5E36.1006_at_mf.sigov.mail.si>, jurij.modic_at_mf.sigov.mail.si says...
>
>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
>

Beware that you will need to have contiguous tablespace to accomodate the the largest table. If I recall, if you have 2 datafiles of 1 GByte/ea for a tablespace, you only have 1 GByte of contiguous tablespace. So a 2Gbyte table that was exported with COMPRESS=Y, will fail on the initial create table statement. Received on Thu Jan 16 1997 - 00:00:00 CST