"rename" fails, can I trap the error and try again?

At periodic intervals I need to rename a large table (to avoid copying thousands of records) and start gathering data in a new table. I try this as follows:

drop table DTMP1;
rename DTABLE to DTMP1;
create table DTABLE as select * from DTMP1 where 1 = 2; ...process records from DTMP1...

However, occasionally (when the database is busy) the rename will fail with:

ORA-00054: resource busy and acquire with NOWAIT specified

How can I trap or retry until the rename succeeds before continuing?

Thanks

--
--Haral Tsitsivas (haral_at_unisol.com)
Received on Thu Sep 21 2000 - 00:00:00 CDT