Re: alter table move and redo log
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Sun, 15 Mar 2009 11:35:14 +0200
Message-id: <49BCCBD2.7070902_at_inter.net.il>
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?
Date: Sun, 15 Mar 2009 11:35:14 +0200
Message-id: <49BCCBD2.7070902_at_inter.net.il>
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
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Mar 15 2009 - 04:35:14 CDT