A table can not be access

  • From: 李建军 <4.4bsd.lite@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 24 Mar 2008 18:15:00 +0800

 

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2008