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
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
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...
Refer to this link......
https://www.indiana.edu/~dbateam/resources/tips/oracle_locking.ppt
its a nice PPT...
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.
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.....
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
thanks
Thanx....
:)
:)
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.....