Re: NOLOGGING creates txns in redo/archive logs

2001-05-01 Thread Connor McDonald 

Only "nologging supported" operations will not result
in logging eg create index, direct load insert and
other such operations...

hth
connor

--- [EMAIL PROTECTED] wrote: >  
>  
> I have been testing logminer and noticed that when I
> alter a table to 
> NOLOGGING, txns are still recorded in the
> redo/archive logs. I thought 
> NOLOGGING was NOT supposed to do this. 
>  
> Anyone know if this is expected behavior?
>  
> At a recent 8i new features class, I explicitly
> asked the instructor this 
> question and he stated that nologging will not cause
> any records to be
> written 
> to the redo/archive logs.
> 
>  
>  
> TIA.
>  
> John Fedock
> iXL, Inc.
> 
>   [EMAIL PROTECTED] 
> http://www.ixl.com  
>  
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (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).


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: NOLOGGING creates txns in redo/archive logs

2001-05-01 Thread Janet Schmitt 265-3334 

John -

I had this same question not too long ago.   This is what I found in 
the documentation.

Only the following operations can make use of the NOLOGGING option: 

  alter table...move partition 
  alter table...split partition 
  alter index...split partition 
  alter index...rebuild 
  alter index...rebuild partition 
  create table...as select 
  create index 
  direct load with SQL*Loader 
  direct load INSERT 

  Other SQL statements (such as UPDATE, DELETE, conventional path
  INSERT, and various DDL statements not listed above) are unaffected
  by the NOLOGGING attribute of the schema object. 

HTH. 

Janet Schmitt.


>  
>  
> I have been testing logminer and noticed that when I alter a table to 
> NOLOGGING, txns are still recorded in the redo/archive logs. I thought 
> NOLOGGING was NOT supposed to do this. 
>  
> Anyone know if this is expected behavior?
>  
> At a recent 8i new features class, I explicitly asked the instructor this 
> question and he stated that nologging will not cause any records to be
> written 
> to the redo/archive logs.
> 
>  
>  
> TIA.
>  
> John Fedock
> iXL, Inc.
> 
>   [EMAIL PROTECTED] 
> http://www.ixl.com  
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janet Schmitt 265-3334
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: NOLOGGING creates txns in redo/archive logs

2001-05-01 Thread james ellis 

This is normal. When a transaction is set to
nologging, minimal redo is written because of Data
Dictionary changes that are occurring.

James
--- [EMAIL PROTECTED] wrote:
>  
>  
> I have been testing logminer and noticed that when I
> alter a table to 
> NOLOGGING, txns are still recorded in the
> redo/archive logs. I thought 
> NOLOGGING was NOT supposed to do this. 
>  
> Anyone know if this is expected behavior?
>  
> At a recent 8i new features class, I explicitly
> asked the instructor this 
> question and he stated that nologging will not cause
> any records to be
> written 
> to the redo/archive logs.
> 
>  
>  
> TIA.
>  
> John Fedock
> iXL, Inc.
> 
>   [EMAIL PROTECTED] 
> http://www.ixl.com  
>  
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (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).


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: james ellis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

NOLOGGING creates txns in redo/archive logs

2001-04-30 Thread jfedock 

 
 
I have been testing logminer and noticed that when I alter a table to 
NOLOGGING, txns are still recorded in the redo/archive logs. I thought 
NOLOGGING was NOT supposed to do this. 
 
Anyone know if this is expected behavior?
 
At a recent 8i new features class, I explicitly asked the instructor this 
question and he stated that nologging will not cause any records to be
written 
to the redo/archive logs.

 
 
TIA.
 
John Fedock
iXL, Inc.

  [EMAIL PROTECTED] 
http://www.ixl.com  
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).