Re: Mass delete (about 100.000 records) ??

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 07 Feb 2000 19:12:34 +0800
Message-ID: <389EA8A2.736D@yahoo.com>

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

Look for any

• indexes on the table
• foreign keys (especiall with delete cascade)
• triggers

which may be slowing your progress...

Also, look for "checkpoint not complete" messages in your alert log. If you find these, you need bigger redo log files..

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Feb 07 2000 - 05:12:34 CST