From: Steve McAreavey <stephen.mcareavey@bt.com>
Subject: Re: How to speed up the import fase of a DB?
Date: 1998/05/27
Message-ID: <356C3A3B.B2634C8F@bt.com>#1/1
Content-Transfer-Encoding: 7bit
References: <6kglle$igr$1@nnrp1.dejanews.com> <01bd8963$8ba584d0$47c3657e@polcar_nt4006> <356C1B91.6932BA16@bt.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: BT Labs, Martlesham Heath, Ipswich, UK
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools,comp.databases.oracle.misc,comp.databases



This is a case of typing before thinking - the DIRECT option is for SQlLoader,
not IMPORT. Aplogies!

Steve

Steve McAreavey wrote:

> Hi,
>
> Also make sure to use the direct=y option on the import - this bypasses the
> conventional buffer and is much faster.
>
> Steve