Link to home
Start Free TrialLog in
Avatar of xLeon1
xLeon1

asked on

ORA-00054

Hello,
when I run my script tables.sql, I will get lots of this error messages.

ORA-00054: resource busy and acquire with NOWAIT specified

Yesterday this message hasn't appeared. I don't know what's wrong.

in script is only sequence of alternating drop table table_nameI [cascade constraints]; create table_nameI (...); I = 1...n

Moreover I noticed, that this message appears only for tables deleted with commands drop table table_name cascade constraints;

thanks
Avatar of kripa_odba
kripa_odba



Because ur table has been locked by some other process.... so when ur trying to execute drop table it couldn't able to  acquire a lock on the table..Its not a big problem...

Try the command after a few minutes or enter the command without the NOWAIT keyword.  Or check any other transaction is running on that particular table.... or any uncomitted transaction...... Commit it and run once again the drop table process.....


If you want to knw more abt oracle locking pls....

Refer to this link......

https://www.indiana.edu/~dbateam/resources/tips/oracle_locking.ppt

its a nice PPT...




Avatar of xLeon1

ASKER

I think that it has nothing to do with locking. Because all tables are mine. You think that somebody could lock them? I'm not using NOWAIT keyword.
It is to do with locking. Other sessions accessing your tables, whether selecting, inserting, updating, deleting, or whatever, will put locks of different levels on your tables.
Some DDL commands have an implicit NOWAIT - so locks of any type on the objects will result in this error.
Please go through the link which i posted.....
Avatar of xLeon1

ASKER

I read that link, but I think that my tables shouldn't be locked. They're mine. But if tables are locked, how do I find out it? How do I unlock them?
ASKER CERTIFIED SOLUTION
Avatar of kripa_odba
kripa_odba

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of xLeon1

ASKER

Thanks. Friend told me that it is probably locked because it's impossible to lock it again. So you were right. But we are both very estonished. I solved it temporarily with creating new tables with similar names. Thanks for that script, I will certainly try it, in the time I understand it and will have some time.

thanks
Thanx....


:)