Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Deletion Of 160 Million Rows.

Deletion Of 160 Million Rows.

From: Sheldon Quinny <sheldonquinny_at_gmail.com>
Date: Tue, 8 Feb 2005 15:09:23 +0530
Message-ID: <109acacc0502080139575b773d@mail.gmail.com>


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
Received on Tue Feb 08 2005 - 04:42:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US