From oracle-l-bounce@freelists.org Thu May 20 15:37:18 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i4KKb3902790 for ; Thu, 20 May 2004 15:37:13 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i4KKar602739 for ; Thu, 20 May 2004 15:37:03 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F298972CBD0; Thu, 20 May 2004 15:25:29 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08922-90; Thu, 20 May 2004 15:25:29 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 75B6572CB45; Thu, 20 May 2004 15:25:19 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 20 May 2004 15:23:55 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 26E0F72C971 for ; Thu, 20 May 2004 15:23:54 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08922-41 for ; Thu, 20 May 2004 15:23:53 -0500 (EST) Received: from tera.umi.com (tera.umi.com [192.195.245.144]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 846EA72C858 for ; Thu, 20 May 2004 15:23:53 -0500 (EST) Received: from aabo-exchange04.bos.il.pqe (aabo-exchange04.bos.il.pqe [172.24.3.67]) by tera.umi.com (8.12.10/8.12.10) with ESMTP id i4KKdoO6026097 for ; Thu, 20 May 2004 16:40:03 -0400 Received: from bosmail00.bos.il.pqe ([172.24.3.64]) by aabo-exchange04.bos.il.pqe with Microsoft SMTPSVC(6.0.3790.0); Thu, 20 May 2004 16:40:11 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6556.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: DELETE FROM table UNRECOVERABLE? Date: Thu, 20 May 2004 16:40:04 -0400 Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF03B45513@bosmail00.bos.il.pqe> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: DELETE FROM table UNRECOVERABLE? Thread-Index: AcQ+qQQBKdoWYyg/QoqiB3yRwIyOygAAOrTQAAApjkA= From: "Bobak, Mark" To: X-OriginalArrivalTime: 20 May 2004 20:40:11.0195 (UTC) FILETIME=[A54E48B0:01C43EAA] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1003 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Now, now, Waleed! Play nice! ;-) -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Khedr, Waleed Sent: Thursday, May 20, 2004 4:36 PM To: oracle-l@freelists.org Subject: RE: DELETE FROM table UNRECOVERABLE? Actually it works for inserts too :) insert into unrecoverable values .... Waleed -----Original Message----- From: Thomas Jeff [mailto:jeff.thomas@thomson.net] Sent: Thursday, May 20, 2004 4:27 PM To: oracle-l@freelists.org Subject: DELETE FROM table UNRECOVERABLE? I'm seeing this statement being issued in one database. I cannot find the UNRECOVERABLE keyword in the 9i SQL Reference. Is UNRECOVERABLE perhaps an old keyword that is now ignored by Oracle? I did some quick testing with AUTOTRACE, and noted no difference for the values for Redo Size as compared to a DELETE w/o UNRECOVERABLE, nor did it=3D20 have any impact on the HWM. -------------------------------------------- Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: jeff.thomas@thomson.net Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba -------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------