From oracle-l-bounce@freelists.org Tue Feb 8 04:42:06 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j18Ag6Ck029326 for ; Tue, 8 Feb 2005 04:42:06 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j18Ag6em029321 for ; Tue, 8 Feb 2005 04:42:06 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 969FC6E524; Tue, 8 Feb 2005 04:41:04 -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 21422-03; Tue, 8 Feb 2005 04:41:04 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0F7676E5B3; Tue, 8 Feb 2005 04:41:04 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=qMOsOxBt5UQnEUeQWHGqjkYDbt+gq9vRcJeDbVGQuEvJ+nsncHIVtptLGGIuwa9w26v6+MENjyXntagTT3edFPp0tROq7IoKeGfYRWOluBSoCGYMAUYd/+Xq940yYNXaFvhvkvri2v+HkZQfRfzP4ICXYdkMhoXSV6fFJhOyA/Q= Message-ID: <109acacc0502080139575b773d@mail.gmail.com> Date: Tue, 8 Feb 2005 15:09:23 +0530 From: Sheldon Quinny To: oracle-l@freelists.org Subject: Deletion Of 160 Million Rows. Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-archive-position: 15916 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: sheldonquinny@gmail.com Precedence: normal Reply-To: sheldonquinny@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: Hi, I Would Just LIke To Ask Whether It Is Possible To Delete 60 Million Rows. At A Strech And Without Undo Contention. The Requirenment Is To Delete 60 Million Records From The 160 Million Records. Its An OLTP System. Is There An Way To Lessen The Effort Taken By Server Process. SInce Its An OLTP DB. Answers Should Be Related To Oracle 9x. Sheldon. -- http://www.freelists.org/webpage/oracle-l