Re: insert and append hint

From: Simon <stemp1ar_at_yahoo.com>
Date: 19 Jul 2001 19:25:19 -0700
Message-ID: <8fe904ce.0107191825.38ae93c4@posting.google.com>

Do you have to worry about rollback segment space restrictions???

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.
Received on Thu Jul 19 2001 - 21:25:19 CDT