Re: alter table move and redo log
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Sun, 15 Mar 2009 09:19:31 +0200
Message-id: <49BCAC03.2070600_at_inter.net.il>
If I run:
Alter table move nologging lob ...
1) Does the "nologging" part become permanent for the table or is it just for the move.
2) Will "Alter table logging" after the move command reactivate the logging of transactions for the table.
3) Is there an option to suppress login just for the move, like append does for insert?
Date: Sun, 15 Mar 2009 09:19:31 +0200
Message-id: <49BCAC03.2070600_at_inter.net.il>
If I run:
Alter table move nologging lob ...
1) Does the "nologging" part become permanent for the table or is it just for the move.
2) Will "Alter table logging" after the move command reactivate the logging of transactions for the table.
3) Is there an option to suppress login just for the move, like append does for insert?
Adar Yechiel
Rechovot, Israel
Kenneth Naim wrote:
> 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.
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Mar 15 2009 - 02:19:31 CDT