| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: truncate /*+append*/
On Thu, 02 Mar 2006 11:43:08 -0800, cpiodumpv wrote:
> truncate B.
> alter table B nologging
>
> insert /*+append*/ into B select < do update on A here>.
>
> I understand that this will generate some redo but will it generate any
> UNDO?
And just why wouldn't it generate undo?
-- http://www.mgogala.comReceived on Thu Mar 02 2006 - 20:26:10 CST
 |
 |