Re: How to exit from pl/sql

From: Andrew M <>
Date: Tue, 5 Feb 2008 06:05:18 -0800 (PST)
Message-ID: <>

> - 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