Re: Making sure all objects moved
- From: Jared Still <jkstill@xxxxxxxxx>
- To: belvdr@xxxxxxxxx
- Date: Thu, 17 Nov 2005 14:28:21 -0500
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@xxxxxxxxx> 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@xxxxxxxxx> 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)
> >
>
>
Other related posts:
