Re: Difficulty importing large table

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 4 Oct 2001 23:00:33 +0200
Message-ID: <trpjln3368lm32@news.demon.nl>

"Travis Hamilton" <thamilton_at_pier1.com> wrote in message news:5ff9d90e.0110041246.74dee346_at_posting.google.com...
> 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.

1 - specify a large buffer parameter
2 drop any indexes on the table
3 Post more details on your config

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Oct 04 2001 - 16:00:33 CDT