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>
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 don¡¯t know what was happened
>It¡¯s 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-lReceived on Mon Mar 24 2008 - 06:24:23 CDT