Re: Help! How to delete half of million records using PL/SQL
From: Joschi <apollo11_at_usa.com>
Date: Sat, 15 Jan 2000 00:02:39 +0100
Message-ID: <85oa3u$9dv$1_at_newsmaster01.magnet.at>
Date: Sat, 15 Jan 2000 00:02:39 +0100
Message-ID: <85oa3u$9dv$1_at_newsmaster01.magnet.at>
try using rownum...
greetings from austia
joschi
--
PS: Win32 unterstuetzt jetzt auch Multitasking:
Es kann jetzt gleichzeitig booten und crashen!
(boa, eh!)
<clockwise_at_att.net> schrieb in im Newsbeitrag:
85gn0v$2ts$1_at_nnrp1.deja.com...
> Hello,
>
> I have tried using 7 cursors for loop to delete about half of million
> records from 7 related tables. However, I have to commit often to avoid
> memory overload, which will cause rollback, the result that would wipe
> out hours of wait.
>
> If anyone knows a better way to do this, I'd appreciate it.
>
> Veronica
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Jan 15 2000 - 00:02:39 CET