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: Importing database with LONG colum

Re: Importing database with LONG colum

From: Sebastian Bienkiewicz <bienkiew_at_bph.krakow.pl>
Date: Fri, 16 Apr 1999 11:59:48 +0200
Message-ID: <37170A14.941B2D0E@bph.krakow.pl>


>
> Is it normal that an export process taking 9 hours should take 3 days to
> import?

Yes, it's possible.

>
> The parameter file I am using look like:
>
> FILE=/dev/rmt/0n
> LOG=do_imp.log
> FULL=Y
> COMMIT=Y
> BUFFER=40000000
>
> Would the time it takes to import the data be much shorter if I used
> COMMIT=N instead?

Certainly.

Sebastian. Received on Fri Apr 16 1999 - 04:59:48 CDT

Original text of this message

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