Re: A table can not be access
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-lReceived on Mon Mar 24 2008 - 06:09:34 CDT