Oracle-L: RE: Nologging and redo generation

From: <Sunil_Nookala_at_Dell.com>
Date: Wed, 14 Aug 2002 14:58:27 -0800
Message-ID: <F001.004B5526.20020814145827@fatcity.com>

SQL loader(direct load),direct inserts,
and create table as select...will not generate redo/undo by using NOLOGGING.

Your Transaction is logged while deleting rows, can't be blocked. correct me if I am wrong.

Sunil Nookala
Database Analyst
Dell Corp
Austin, TX

-----Original Message-----
Sent: Wednesday, August 14, 2002 4:48 PM To: Multiple recipients of list ORACLE-L

Can I use the nologging option on simple inert and deletes to eliminate rollback problems and redo generation?

Ron S.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Smith, Ron L.
INET: rlsmith_at_kmg.com

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: 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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Sunil_Nookala_at_Dell.com

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