Re: export on Oracle8

From: Volker Pohlers <Volker.Pohlers_at_lycosmail.com>
Date: Wed, 22 Mar 2000 15:44:24 -0000
Message-ID: <8bambk$4om1r$1@fu-berlin.de>

<sb_cri_at_my-deja.com> schrieb in im Newsbeitrag: 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

check as SYS:
create index source$_obj#_idx on source$( obj#);

>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 22 2000 - 09:44:24 CST