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 - 05:43:29 CDT
