Re: TABLE CANNOT CREATE OR DROP

All,

I think the problem here is probably a messed up data dictionary. If I understand correctly, these are the steps to date:

1. User breaks out of DROP TABLE w/ CTRL+Y (it's a VAX) which had been taking a long time.
2. Any SELECT/ANALYZE/DROP etc against the table hangs.
3. DB is bounced; users are definitely OUT of THERE
4. Any SELECT/ANALYZE/DROP etc against the table hangs.

So, maybe it's time to see what's going on in tab$

Regards,
Charles_Dye_at_corp.dialog.com

> From owner-oracle-l_at_CCVM.SUNYSB.EDU Fri Feb 2 14:25:19 1996
> Date: Fri, 2 Feb 1996 17:16:37 -0500
> From: "TSAWMILL.US.ORACLE.COM" <TSAWMILL_at_US.ORACLE.COM>
> Subject: Re: TABLE CANNOT CREATE OR DROP
> X-To: oracle-l_at_ccvm.sunysb.edu
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_ccvm.sunysb.edu>
>
> --Boundary-8198129-0-0
>
> Now I didn't mean drop the database! I meant to startup in restricted mode,
> to ensure that no users can access the table, then log in as DBA and try to
> drop the table, if that's what you are really trying to do. Don't analyze it
> or anything.
>
>
> Tim Sawmiller
> tsawmiller_at_us.oracle.com
> "The opinions expressed here are my own and not necessarily those of the
> Oracle Corporation".
>
>
> --Boundary-8198129-0-0
> Content-Type: message/rfc822
>
> Date: 02 Feb 96 13:54:53
> From:"\" <Katherine.OR_at_SYNTEX.COM>
> To: Multiple,recipients,of,list,ORACLE-L,ORACLE-L_at_CCVM.SUNYSB.EDU
> Subject: Re: TABLE CANNOT CREATE OR DROP
> Reply-to: ORACLE-L_at_CCVM.SUNYSB.EDU
> X-Orcl-Application: Sender: "ORACLE database mailing list."
> <ORACLE-L_at_CCVM.SUNYSB.EDU>
> X-To: "ORACLE database mailing list." <ORACLE-L_at_ccvm.sunysb.edu>
> X-Orcl-Application: In-Reply-To: <01I0Q81EQMCY003H5S_at_SYNTEX.COM>
>
>
> Tim,
> I re-cycled the database but I did not have
> time to drop it. I just have 15 min down time.
> I tried to use ANALYZE table
> ADE_QRY.WHATART_LOCAL validate sturcture. It hung
> without return any oracle error or trace file.
>
> Kathy
> katherine.or_at_syntex.com
>
>
>
> Hi,
> I got a new had problem to create or drop
> specific table name on production. This table name
> called WHOART_LOCAL. We still didn't get any response
> from ORACLE technical support. I try to use
> Analaze table WHOART_LOCAL validate structure. It does
> not return anything. It look hung. Did any can give me
> any suggestion ?
>
> TIA
>
> Kathy (Katherine.or_at_syntex.com)
Received on Fri Feb 02 1996 - 18:17:23 CST