Re: Difficulty importing large table

in article 5ff9d90e.0110041246.74dee346_at_posting.google.com, Travis Hamilton at thamilton_at_pier1.com wrote on 10/4/01 1:46 PM:

> Currently I am trying to import a large table (15 million+ rows) and
> the process is taking in excess of 21 hours. The table is partitioned
> into 28 partitions. The server hardware is an IBM M80 running AIX
> 4.3.3, the ORACLE version is 8.0.6 64-bit and the server has 10 Gig or
> RAM connected to an IBM Shark storage array. This import is taking too
> long, in my opinion.
>
> I would appreciate ANY advice, recommendations or insights into this
> problem.

This seems very excessive - I presume you have a big a buffer as possible, there are no indexes in place (and you are not importing them), constraints are not being imported, rollbacks are sized correctly, tablespace is not auto extending, you are committing regulary etc.

Also - do you have access to the source database - an extract and corresponding direct path SQLLoad will always be faster than an export/import. Hwoever all of the above will apply to this approach also.

And if both source and target where Oracle8i on the same platform, you could of course do this with transportable tablespaces. Received on Thu Oct 04 2001 - 20:44:59 CDT