How do you do this w/o a DBA?

From: <clockwise_at_att.net>
Date: Wed, 12 Jan 2000 00:53:18 GMT
Message-ID: <85gj9o$bi$1@nnrp1.deja.com>

Hello,

I'm in a situation that I need to delete a huge amount of data without a DBA. Any advice would be appreciated.

Suppose you have a table whose associated with 6 other tables shown as below:

tbl_parent(parent_id, parent)
tbl_child1(child1_id, child1)
tbl_grandchild1(grandchild1_id, child1, grandchild1)
tbl_child2(child2_id, child2)
tbl_child3(child3_id, child3)
tbl_child4(child4_id, child4)
tbl_grandchild4(grandchild1_id4, child4, grandchild4)

There are about 80000 records in tbl_parent that need to be deleted. There are about 4 times as many records in each child table.

Is there any other way to delete all of them other than using cursor for loops
using PL/SQL?
The problem I encounter is that when it reaches the memory limit, oracle will
rollback everything.

Thanks in advance for any advice.

Veronica

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 11 2000 - 18:53:18 CST