Re: How to exit from pl/sql
Date: Wed, 30 Jan 2008 10:24:01 -0800 (PST)
On Jan 30, 12:01 pm, wagen..._at_yahoo.com wrote:
> Thanks David for responding.
> 500 is just a test number. What we are trying to do:
> - 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.
> Your suggestion for select count(*) may not work in this scenario.
Have you also setup a process to disable the constraints before truncating, and then re-enabling after truncate completes succesfully?
Arun Received on Wed Jan 30 2008 - 12:24:01 CST