Re: Mass delete (about 100.000 records) ??

Assuming just selecting the 100.000 records doesn't take by far that long, my guess would be that you have some foreign key constraints (with cascade on delete) on other tables' columns which reference the table you want to delete from. And one or more of these other tables do not have the foreign key constrained columns indexed.

Thomas Kyte posted a neat script which checks for exactly that, when I had a similar problem. If you think the foreign keys might be your problem, and he doesn't answer directly to you send me an email and I can send it to you on Monday.

Christian

Andreas Eggen wrote:
>
> Hi,
>
> i have the question how to delete about 100.000 records in an oracle table.
>
> we do this with an sql statement that select the records to delete and then
> perform the action.
>
> The Problem is, deleting of all records takes about 2 Hours ??
>
> Anyone here in the group who has a solution for this problem ??
>
> thanks in advance
>
> Andi
Received on Fri Feb 04 2000 - 19:58:36 CST