Re: alter table move and redo log
Date: Sun, 15 Mar 2009 11:35:14 +0200
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?
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.