Re: A table can not be access

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Mon, 24 Mar 2008 19:24:23 +0800
Message-Id: <200803241124.m2OBOZNH001369@smtp41.singnet.com.sg>

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:
>
>Hi
>And I tried to delete a foreign key by
>ALTER TABLE BN_MAINS DROP CONSTRAINT BN_MAINS_FOR
>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
http://hemantoracledba.blogspot.com

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 24 2008 - 06:24:23 CDT

Original text of this message