Re: A table can not be access
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: 4.4bsd.lite@xxxxxxxxx, <oracle-l@xxxxxxxxxxxxx>
- 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:
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
