If you are an Oracle programmer, then you’ve probably encountered the ORA-00054: resource busy and acquire with NOWAIT specified exception when attempting to truncate a table. When this happens during the day, you can usually just wait a few minutes (or go and commit your other open sessions…), but what about when you are truncating tables as part of a script which runs overnight? Are you tired of being woken up so you can simply rerun the script?
Well check out this script, then! It is a very simple PL/SQL procedure which accepts 1 or 2 arguments.
Updated November 8, 2013 – I have verified this on Windows 7 Enterprise Edition. Have you ever wanted to see your Oracle output or log files open in your custom text editor instead of an IE window? I use Notepad++ (FREE) for text editing. Every time I open an output file or log file which […]
If this article doesn’t help you, consider dropping me a note with your concern. I have thousands of lines of code for hundreds of Oracle problems I’ve faced and would publish ones that people told me would be helpful. How many times have you been told by Oracle Support that you should run a concurrent […]