Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: resource busy!
Thank you for your answers, but i could not wait and i did a restore from a
backup.
Thank you.
Pinto.
"sroesch3" <sroesch3_at_attbi.com> wrote in message
news:zBzO8.191155$352.11749_at_sccrnsc02...
> Pinto wrote:
>
> > 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.
> Check with the help of v$lock, who is locking rows
>
> Steve
Received on Mon Jun 17 2002 - 23:57:00 CDT