Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: resource busy!
Ignore this response.
It is trash
Regards
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address
On Sat, 15 Jun 2002 12:43:29 +0200, "shrinad_at_ora-india.com" <daekw_at_yahoo.com> wrote:
>you have to delete the locks from the locktable
>like in access
>
>"Pinto" <ucanmailme_at_india.com> schrieb im Newsbeitrag
>news:aea4kk$nk9$1_at_news.mch.sbs.de...
>> Hello,
>> When i try to insert into a table that i have from sqlplus, the session
>just
>> hangs.
>> is it because there is a full table lock on that table?
>>
>> i tried
>> lock table <table name> in exclusive mode nowait and it returns resource
>> busy error.
>> i took an export of the table, tried to drop the table....not able to do
>it.
>>
>> finally i shutdown the database and restarted it.
>>
>> again i tried drop table.....no luck :-( it still gives me resource busy
>> error!!!
>>
>> whats wrong with this table. i am able to select from the table but no
>> update, insert or delete is possible. either can i drop that table even
>> after a database restart.
>>
>> all my work has come to a stand still because of this. can anybody pls
>help?
>>
>> thanks,
>> Pinto.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
Received on Sat Jun 15 2002 - 07:29:45 CDT