Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Speeding up imports

Re: Speeding up imports

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 11 Aug 1999 16:56:28 +0800
Message-ID: <37B13ABC.7356@yahoo.com>


NetComrade wrote:
>
> Hi folks,
>
> Is there are anyway to speed up import?
> That thing is taking forever!
> Should I set commit=n (I set buffer to 300m, and my TEMP is 500M),
> should I do analyze=n?
> We have a Sun 450 with 4 processors, and the machine is 50%+ idle
> (also Oracle 7.3.4 on top).
> I don't want to do parallel tablespace_imports, b/c I will probobly
> have problems with constraints which are going to take forever to
> figure out... unless you know an easy way out :)
>
> Thanx
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email

Try this:

Two exports:
1) data and nothing other related objs (no indexes, no constraints) 2) everything with rows=n

To import:
import (1) first ie just populating the tables use 'strings' and 'grep' on (2) to extract

Use 'sed' to add parallel and unrecoverable clauses (as well as a trailing ";") to your generated files....

This should speed things up considerably...

HTH   --



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Aug 11 1999 - 03:56:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US