Re: alter table move and redo log

From: Yechiel Adar <>
Date: Sun, 15 Mar 2009 11:35:14 +0200
Message-id: <>

You mean that the movement of the blobs will be recorded in the redo log and the nologging will not affect this?
Thats means that my archive log destination will fill up?

Adar Yechiel
Rechovot, Israel

Bobak, Mark wrote:
> Note also, that since 'nologging' only applies to a small subset of operations, worrying about setting a particular object back to 'logging' is probably not very urgent or important. For example, in the case of indexes, the only thing that the object level 'nologging' setting will effect is the next rebuild, if neither 'logging' nor 'nologging' is set in the alter statement. In the case of a table, it's only insert w/ APPEND hint that would be impacted.
> -Mark

Received on Sun Mar 15 2009 - 04:35:14 CDT

Original text of this message