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

Home -> Community -> Usenet -> c.d.o.misc -> question on mass deletes

question on mass deletes

From: Andreas Boehm <andreas_at_andiboehm.de>
Date: Mon, 09 May 2005 12:12:38 +0200
Message-ID: <3e8rcmF1of25U2@news.dfncis.de> 






Hello *.*,



is there a possibility to tune mass deleted on a table, that is linked
to by many other tables using foreign keys. These tables have about
100-200 times more records than it, not null links.
One delete yielding 19000 deleted of the 92000 records lasts about 1.5
hours.


Any suggestions?



regards,


Andreas
Received on Mon May 09 2005 - 05:12:38 CDT












Original text of this message













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