> Hi Gurus,
>
> I have a couple of questions regarding "nologging".
>
> 1) alter table tabname move tablespace tbsname nologging;
>
> How come this sql still generated same amount of redo logs equal to the size of the table?
>
> 2) alter index idxname rebuild tablespace tbsname nologging;
>
> This sql only generate minimum redo logs.
> But the index ends up LOGGING=NO in dba_indexes view.
> How do I turn the logging on for this index?
>
> Thanks,
>
> Roger Xu
> Database Administrator
> Dr Pepper Bottling Company of Texas
> (972)721-8337
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Roger Xu
INET: roger_xu_at_dp7uptx.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Oct 22 2003 - 15:39:34 CDT
