A table can not be access
From: 李建军 <4.4bsd.lite_at_gmail.com>
Date: Mon, 24 Mar 2008 18:15:00 +0800
Message-ID: <47e77f30.26d7720a.1fc3.6023@mx.google.com>
Date: Mon, 24 Mar 2008 18:15:00 +0800
Message-ID: <47e77f30.26d7720a.1fc3.6023@mx.google.com>
Hi
I have a rac oracle 9204 ,IBM p570 aix5304
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
How can I return it?
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 24 2008 - 05:15:00 CDT