alter table move and redo log

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Sun, 15 Mar 2009 08:32:43 +0200
Message-id: <49BCA10B.90104_at_inter.net.il>

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 Received on Sun Mar 15 2009 - 01:32:43 CDT