Help! How to delete half of million records using PL/SQL
From: <clockwise_at_att.net>
Date: Wed, 12 Jan 2000 01:56:02 GMT
Message-ID: <85gmvc$2tj$1_at_nnrp1.deja.com>
Hello,
Date: Wed, 12 Jan 2000 01:56:02 GMT
Message-ID: <85gmvc$2tj$1_at_nnrp1.deja.com>
Hello,
[Quoted] 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 Wed Jan 12 2000 - 02:56:02 CET