Re: insert and append hint

In article <8fe904ce.0107191825.38ae93c4_at_posting.google.com>, stemp1ar_at_yahoo.com says...
>
>Do you have to worry about rollback segment space restrictions???
>

it (direct path insert) doesn't generate rollack

...
Advantages of Direct-Load INSERT

A major benefit of direct-load INSERT is that you can load data without logging redo or undo entries, which improves the insert performance significantly. Both serial and parallel direct-load INSERT have this performance advantage over conventional path INSERT.
.........

>Thomas Kyte <tkyte_at_us.oracle.com> wrote in message
>news:<9iks8v01m5d_at_drn.newsguy.com>...
>> In article <3B4DD464.91772C81_at_usa.net>, Tommy says...
>> >
>> >
>> >Question:
>> >
>> >Does the append hint give me the same benefit on insert /*+ append */
>> >into...values; like on insert /*+ append */ into...select...;
>> >
>> >Thanks.
>> >Tommy
>> >
>>
>> nope. it is for bulk, direct path large scale loads of data.
>>
>> singleton inserts are processed as normal.
>>
>> see
>>http://technet.oracle.com/doc/oracle8i_816/server.816/a76965/c21dlins.htm#7917
>>
>> for details.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp