Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h06K1nf04631 for ; Mon, 6 Jan 2003 14:01:49 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h06K1nc04626 for ; Mon, 6 Jan 2003 14:01:49 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA75182; Mon, 6 Jan 2003 08:42:21 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 005278DA; Mon, 06 Jan 2003 07:28:43 -0800 Message-ID: Date: Mon, 06 Jan 2003 07:28:43 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Fink, Dan" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Fink, Dan" Subject: RE: No logging question Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit If you use the NOLOGGING option, you still generate redo entries (which become archive log entries). Even if the DML is not logged, the generation of UNDO is still logged for rollback purposes. -----Original Message----- Sent: Monday, January 06, 2003 2:34 AM To: Multiple recipients of list ORACLE-L Hi All, I want to avoid generation of archivelogs against all the DML applied to some tables. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GL2Z/ INF DBA BENLATRECHE INET: kbenlatreche@avl.sonatrach.dz 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@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.net -- Author: Fink, Dan INET: Dan.Fink@mdx.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@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).