Re: export on Oracle8

From: Faheem <ijaz.faheem_at_cressoft.com.pk>
Date: Wed, 22 Mar 2000 18:31:38 +0500
Message-ID: <8bbkop$n7n$1@sussi.cressoft.com.pk>

You can use the direct path (DIRECT=Y) load to speed up the export. Also specify a large size buffer (e.g. BUFFER=1000000)

Hope it'll help.
Faheem

<sb_cri_at_my-deja.com> wrote in message news:8babi9$j25$1_at_nnrp1.deja.com...
> If have a small database on Oracle7 the export file has a size of about
> 400MB. The duration of a full export is about 20 minutes. I installed
> the same database on the same machine on oracle8. I import the the
> Oracle7 export. Afterwards I export the Oracle8 database. The duration
> of this export spents over 4 hours.
> Has anybody an idea how to speed up the export?
> Stefan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 22 2000 - 07:31:38 CST