Tom is correct.
What was I thinking. (apparently I wasn't )
INSERT's generate very little undo, as there is no before image to save.
Learn something every day here. :)
Jared
On 11/17/05, Thomas Fox <belvdr_at_yahoo.com> wrote:
>
> In regards to commit=y, there is a discussion regarding the amount of undo
> that
> is needed. Tom Kyte gave one answer, while the Oracle 9i docs gave a
> different
> answer.
>
>
> http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:230214032357
>
> My question to Tom, and his reply with an example, is near the bottom.
> Just
> search for "Tom Fox from Cinti, OH".
>
> Tom
>
> --- Jared Still <jkstill_at_gmail.com> wrote:
>
> > commit=y - Commits the data every time the buffer fills.
> > easier on UNDO resources if it is a large import.
> > Some imports should not be done this way, appending
> > data for instance. ( not fun to fix if the imp dies part way through,
> > after 1+ commits)
> >
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 17 2005 - 14:32:01 CST
