Re: data corruption

Would seem that a "select *" is selecting all rows and would therefore have selected the problem row.

Anyway, what is the error that the exp utility gives when you run it ?

"jh" <jhaisu_at_yahoo.com> wrote in message news:b0ifod$1h3$1_at_bob.news.rcn.net...
> can't even export right now.
>
> If I run select * from that table, I don't have any problems.
> but once I select the row with the problem, the database hangs
> and I would need to restart the oracle service.
>
> "Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message
> news:3e29ae56$1_2_at_mk-nntp-1.news.uk.worldonline.com...
> > "JustAnotherDBA" <jadba_at_bellsouth.net> wrote in message
> > news:V67W9.7141$F_3.6131_at_news.bellsouth.net...
> > > Do you know why you have data corruption in the 1 table?
> > >
> > > That would bother me the most. Try doing a full export and you may
find
> > more
> > > tables. If you do, seems you could have some disk problems too ?
> > >
> > > Anyway, just a thought.
> > >
> > FWIW:
> >
> > Usually when people report 'data corruption' in an Oracle database, they
> > don't really mean it, they mean 'bad or logically inconsistent data'.
> > Every time I hear the expression, I start asking gentle questions before
> > panicking....
> >
> > Regards,
> > Paul
> >
> >
> >
>
>
Received on Mon Jan 20 2003 - 22:46:22 CST