Re: How to exit from pl/sql

From: Andrew M <andrew.markiewicz_at_gmail.com>
Date: Tue, 5 Feb 2008 06:05:18 -0800 (PST)
Message-ID: <d233855c-79e7-4ab9-beb7-e194cdcb7d02@d70g2000hsb.googlegroups.com>


>
> - we have a table that has a high amount of DML all the time (24x7) in
> fact every second
> - at midnight we want to truncate the table. the reason for the pl/sql
> procedure is to get around the ORA-00054 resource busy error.
>

You may want to look at partitioning the table by insert timestamp. When it hits midnight a new partition will be used and you can do whatever you need to the older partition (truncate and reuse) without a resource busy error.

Andrew Received on Tue Feb 05 2008 - 08:05:18 CST

Original text of this message