RE: alter table move and redo log

From: Kenneth Naim <>
Date: Sun, 15 Mar 2009 02:56:47 -0400
Message-ID: <8E13EC3A7D9E42B7A4059794840EE2C4_at_KenPC>

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.

-----Original Message-----

From: [] 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.


Adar Yechiel
Rechovot, Israel


-- Received on Sun Mar 15 2009 - 01:56:47 CDT

Original text of this message