Re: A table can not be access

From: Peter McLarty <peter.mclarty_at_pacificdbms.com.au>
Date: Mon, 24 Mar 2008 21:09:34 +1000
Message-Id: <1206356974.6127.5.camel@notebook5.pacificdbms.com.au>


Hi 李建军

How big is the table that the constraint is on It may take a while on a large table as it may need to drop the index that is associated with the constraint. What was the purpose of the constraint? was it a primary key, a check, a foreign key reference.

You may just be wating a while.

Look in longops for whether your process is taking up time. Have a look at V$SQLAREA for your drop statement.

HTH Cheers

Peter  

On Mon, 2008-03-24 at 18:15 +0800, 李建军 wrote:
>
>
> 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-l
Received on Mon Mar 24 2008 - 06:09:34 CDT

Original text of this message