Re: Difficulty importing large table

From: Stephen Ashmore <sashmore_at_neonramp.com>
Date: Thu, 4 Oct 2001 17:23:00 -0000
Message-ID: <trpo995cnind64@corp.supernews.com>

You may also which to check:
ensure any referential constraints are disabled. Any triggers are disabled.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:trpjln3368lm32_at_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 - 12:23:00 CDT