Re: A table can not be access
Date: Mon, 24 Mar 2008 19:24:23 +0800
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
>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
>In sqlplus, then sqlplus hang
Hemant K Chitale