RE: alter table move and redo log

From: Kenneth Naim <kennaim_at_gmail.com>
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: 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
To: ORACLE-L
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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Sun Mar 15 2009 - 01:56:47 CDT