| ORA-00054: resource busy and acquire with NOWAIT specified. [message #302115] |
Sat, 23 February 2008 13:52  |
it_me24
Messages: 167
Registered: March 2006
Location: delhi
|
Senior Member |
|
|
Hi Everybody,
I am facing a problem while truncating a table.
please have a look onto the scenario below.
SQL> truncate table SUKANT.UIBSCDRPOSTED;
truncate table SUKANT.UIBSCDRPOSTED
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified.
SQL>select OBJECT_NAME,OBJECT_ID from dba_objects where OBJECT_NAME='UIBSCDRPOSTED' and owner='SUKANT' and OBJECT_TYPE='TABLE'
OBJECT_NAME OBJECT_ID
-------------------------------------------------------------------------------------------------------------------------------- ----------
UIBSCDRPOSTED 6615409
SQL> select SESSION_ID from v$locked_object where OBJECT_ID='6615409';
SESSION_ID
----------
722
SQL> alter system kill session '722,23807' immediate;
alter system kill session '722,23807' immediate
*
ERROR at line 1:
ORA-00031: session marked for kill
then after running the truncate, got the error message again.
SQL> truncate table dishnettest.UIBSCDRPOSTED;
truncate table dishnettest.UIBSCDRPOSTED
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
Please Help.....
Thanks
|
|
|
|
|
|
|
|
|
|
| Re: ORA-00054: resource busy and acquire with NOWAIT specified. [message #302125 is a reply to message #302115] |
Sat, 23 February 2008 14:42  |
it_me24
Messages: 167
Registered: March 2006
Location: delhi
|
Senior Member |
|
|
THANKS MICHEL.....
I am able to truncate the table now.
but while using the below query i am facing an error.
SQL> select username,password from dba_users where username='SUKANT';
USERNAME PASSWORD
------------------------------ ------------------------------
SUKANT 2FF2B63193FB7DB9
SQL> CONNECT SUKANT/2FF2B63193FB7DB9
ERROR:
ORA-01017: invalid username/password; logon denied
Thanks
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
