Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: corrupted table?

Re: corrupted table?

From: Matthias Rogel <rogel_at_web.de>
Date: Wed, 30 Oct 2002 11:59:54 +0100
Message-ID: <apoe3a$3eh4u$1@ID-86071.news.dfncis.de>


hi

what does
analyze table <tabname> validate structure cascade online

result in ?

mr

Gumuz wrote:
> hi all,
>
> i have this strange problem. my guess is that it's a bad-installation, but i
> want to be sure, before i have to re-install a customers database. so here
> is my problem...
>
> so once in a while, i've this strange behavior in 'some' tables,
> 'sometimes'. sometimes a simple 'select *' doesn't even work. recently i got
> the problem that a select was working fine. but when i used one of the
> columns in a join, it messed up, got stuck, had to cancel.
>
> now in all these cases i could solve the problem by dropping and recreating
> the table with the original data put back in. then it works.... for a while.
> it seems that some tables have the tendencie to give this error more then
> others, but then again... not always.
>
> ok guys/girls... i know it's a pretty vague story what i'm putting up here,
> i hope you know something i can do about this, besides making a new
> installation.
>
>
> thanks,
>
> Guyon
>
>
Received on Wed Oct 30 2002 - 04:59:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US