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,

[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

Original text of this message