Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What could be wrong with my DB if "drop table" hangs forever?

Re: What could be wrong with my DB if "drop table" hangs forever?

From: gazzag <gareth_at_jamms.org>
Date: Mon, 11 Jun 2007 05:44:29 -0700
Message-ID: <1181565869.715175.168820@h2g2000hsg.googlegroups.com>


On 11 Jun, 01:57, Ron Schnell <schn..._at_gmail.com> wrote:
> Oracle 10g:
> I create a small table with:
> create table foo (bar number(10), bletch varchar(32));
> Insert one row:
> insert into table foo (bar, bletch) values (25, 'test');
> Then try to drop it:
> drop table foo;
>
> The command hangs forever (1 hour so far). I'm looking for areas to
> check for trouble (undo tablespace?). Any pointers to scripts I could
> use (as sysdba, if required) would be great.

In addition to Sybrand's answer, it may be worth monitoring the alert log too.

HTH -g Received on Mon Jun 11 2007 - 07:44:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US