Try intermitent commits with DBMS_SESSION.FREE_UNUSED_USER_MEMORY
<clockwise_at_att.net> wrote in message news:85gj9o$bi$1_at_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 Wed Jan 12 2000 - 18:13:33 CST
