RE: alter table move and redo log
Date: Sun, 15 Mar 2009 02:56:47 -0400
You can do move the table nologging and alter it logging after the move or do it logging and backup your archive logs to tape frequently during the process.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yechiel Adar
Sent: Sunday, March 15, 2009 2:33 AM
Subject: alter table move and redo log
Last night I tried to do: alter table move lob ... and the database froze on archive log destination full.
From the docs I see that using the NO LOGGING clause will stop also later changes to be unlogged, which I do not want.
How do I move the table without filling up the archive destination? No - I can not increase it.
http://www.freelists.org/webpage/oracle-l Received on Sun Mar 15 2009 - 01:56:47 CDT