Re: Importing huge data

T. Bone wrote:

> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
> news:<3f550339$0$14559$afc38c87_at_news.optusnet.com.au>...
>> The direct path insert is a modified form of the insert statement.
>> Instead of it reading 'insert into X values ('A','B','C')', it reads
>> 'insert /*+APPEND */ into X values ('A",'B','C')'. The append hint there
>> causes data blocks to be constructed entirely in memory, and then slammed
>> down on disk in a way that's guaranteed not to interfere with data that's
>> already in the table. By doing the bulk of its work in memory, it's
>> faster than a normal insert. And by respecting the nologging keyword, it
>> has less overhead than a regular insert, and is thus faster again.
>
> Howard,
> The Oracle docs state that direct path insert only works when using
> the format Insert /*+APPEND */ into ... Select ... from syntax. Here
> is the reference from Oracle:
>

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c21dlins.htm#11358
>
> "Note: Direct-path INSERT supports only the sub query syntax of the
> INSERT statement, not the VALUES clause. For more information on the
> subquery syntax of INSERT statements, see Oracle9i SQL Reference ".
>
> Is that not correct?
>
> Tommy

Ah, the dangers of cut and paste. It is indeed correct, and I should have watched what I was pasting.

Thanks for the correction.

Regards
HJR Received on Sat Sep 06 2003 - 08:38:27 CDT