rename and BMC backup

From: Gurelei <gurelei_at_yahoo.com>
Date: Thu, 05 Dec 2002 14:14:29 -0800
Message-ID: <F001.00513E4B.20021205141429@fatcity.com>

Hi all.

Yeaterday we were tyring to rename a table. The rename command failed with

ORA-00054: resource busy and acquire with NOWAIT specified

Could that error somewhow be a result of a hot backup running at the same time via BMC. I know that the hot backup doesn't lock table for DML, but this is a DDL command. Is there any scenario that can explain this error by the BMC backup? Our version of Oracle is 8.1.7. Afaik no transactions after the table being renamed have been running at the time

thanks

Gene

---

Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Gurelei
  INET: gurelei_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Dec 05 2002 - 16:14:29 CST