Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news-out.nuthinbutnews.com!propagator2-sterling!news-in.nuthinbutnews.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.vmunix.org!newsfeed01.sul.t-online.de!newsmm00.sul.t-online.com!t-online.de!news.t-online.com!not-for-mail From: Lothar Armbruester Newsgroups: comp.databases.oracle.server Subject: Re: Deletion of Records Date: Tue, 22 Apr 2003 18:51:58 +0200 Organization: T-Online Lines: 19 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: news.t-online.com 1051030487 02 2664 vjT3EoRTfY30U 030422 16:54:47 X-Complaints-To: abuse@t-online.com X-ID: bofOq-ZSoeU2UCe3EVjDUUV0KPOOHGvJGY3GBCDCw6WEDVbQux4yUA User-Agent: Pineapple News 0.9.8 [PLAID BETA], BeOS (Intel) 5.0.3 X-Program-URL: http://www.beosdevelopers.org/brunsona/pineapplenews.html X-Registered-To: Lothar Armbruster Xref: core-easynews comp.databases.oracle.server:184097 X-Received-Date: Tue, 22 Apr 2003 09:54:43 MST (news.easynews.com) priya wrote: > I have a table with 20 million records. I have one primary and 4 > secondary > indexes. If i try to delete certain records (80%) of the records. It > takes > days to delete. How to do it fast. Hello Priya, one option is to dump out the rows to keep into a flat file, truncate the table and then load the flat file back into the database using SQL*Loader with direct path. Hope that helps, Lothar -- Lothar Armbrüster | la@oktagramm.de Hauptstr. 26 | la@heptagramm.de D-65346 Eltville | lothar.armbruester@t-online.de