Hi,
i ran a script and got error below. Why am i getting error "ORA-00054: resource busy" when adding a default constraint to table? On other evironments such error didn't occure, only in particualr special one the error occured.
Is it possible that table has too much traffic/locks i nthat environment? How can i rewrite my script?
Should i instal lthe script in OFFLINE mode?
---
In Oracle 11g, Linux Os i runned such script (in Online mode, system not offline):
ALTER TABLE Casino.Physicaltables ADD WinnerListEnabled NUMBER(1);
COMMENT ON COLUMN Casino.Physicaltables.WinnerListEnabled IS '<BOOLEAN> Defines if winner list is turned on or off.';
ALTER TABLE Casino.Physicaltables MODIFY WinnerListEnabled DEFAULT 0;
ALTER TABLE Casino.Physicaltables MODIFY (WinnerListEnabled CONSTRAINT NC_Pts_WinnerListEnabled NOT NULL NOVALIDATE);
UPDATE Casino.Physicaltables SET WinnerListEnabled = 0 WHERE WinnerListEnabled IS NULL;
COMMIT;
ALTER TABLE Casino.Physicaltables MODIFY CONSTRAINT NC_Pts_WinnerListEnabled ENABLE VALIDATE;
And output was such:
\\dserver\Live\release\12.6\0.10\sql\live_sql_12.4.0.5_to_12.6.0.10.zip
Elapsed: 00:00:00.09
ALTER TABLE Casino.Physicaltables MODIFY WinnerListEnabled DEFAULT 0
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified