Can someone please help me in adding a foreign key constraint to a table. Below is the error message that I got whenever I tried to execute the ddl:
SVRMGR> ALTER TABLE change_1
2> ADD FOREIGN KEY (PKG_POOL_ID) REFERENCES OM_AO_PKG_POOL( PKG_POOL_ID);
ALTER TABLE change_1
ORA-00054: resource busy and acquire with NOWAIT specified
How do I get around this busy message.