Re: what's the impact of this

From: Anatoly Moskovsky <avm_at_trais.com.ua>
Date: Fri, 24 Aug 2001 13:52:07 +0300
Message-ID: <TRS10615D3F3@trais.com.ua>

Hi!

• On august 24 blah wrote:

 b> Could someone discribe the possible impact/impacts of running this  b> sql against a busy production database.

 b> alter table customer add(deleted varchar2(1) default 'N');

If there are uncommitted changes(row locks) in the table, you'll get ORA-00054 resource busy ...

Bye

---

Anatoly Moskovsky, Oracle Developer avm_at_sqlbatch.com [SQL Batch/Oracle, DBA tools, reverse engineering, scripting extensions]: http://sqlbatch.com/sb/ Received on Fri Aug 24 2001 - 05:52:07 CDT