Re: imp/exp: extends problems...

From: <markp7832_at_my-deja.com>
Date: Mon, 01 Nov 1999 18:10:53 GMT
Message-ID: <7vkl39$cf5$1@nnrp1.deja.com>

In article <381B3596.5A350E6E_at_videotron.ca>,   Andre Couture <andre.couture_at_search-n-find.com> wrote:
>
> Hi all,
>
> I have a database under a Sinix platform that I access via Oracle8
> /Linux
>
> I want to exp from one and import to the other.
>
> The export file is created without problems.
>
> But when trying to import it via imp I get fatal errors on EXTENDS.
> The original database was created with very large initial extends
>
> How can I sucessfully "copy" the content of some tables from
> one/another?
>
> So far I've edited the export file to reduce the EXTEND values, but
that
> only works for small exports.
> Some tables have over 6millions rows for over 600mb.
>
> Please Cc to my email as well.
>
> Thanks
> Andre
> --

---

Two points:
1) Do your export with compress=n to prevent the import from creating the objects with an initial extent equal to the total size of the exported object
2) Make sure your new database tablespaces are large enough to hold every object that has to fit in them

Personally, I would generate the table and index code and pre-allocate my objects allocating the large objects first then I would use the ignore=y option on the import. You will also need to either create a special large rollback segment to support you import or use commit=y on the imp.

Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 01 1999 - 12:10:53 CST