Re: A table can not be access

From: Hemant K Chitale <>
Date: Mon, 24 Mar 2008 19:24:23 +0800
Message-Id: <>

Presumably, the "ALTER TABLE" and
"DESC" commands are from different sessions ?

Query V$SESSION_WAIT for the session running the "DESC" a few times and see what it is waiting on. Get the EVENT and P1, P2, P3 values.

At 06:15 PM Monday, =?gb2312?B?wO69qL78?= wrote:
>And I tried to delete a foreign key by
>I dont know what was happened
>Its possible the delete operation have not completed
>The table bn_mains cannot be access
>For example , when I run
>Desc bn_mains
>In sqlplus, then sqlplus hang

Hemant K Chitale

Received on Mon Mar 24 2008 - 06:24:23 CDT

Original text of this message