Re: data corruption

ora-03113 end of communication file channel from the exp util

the table has been recreated and i don't have the problem right now. but don't know what caused it. will be doing a scan on the harddrive to make sure it's not a disk problem.

"JustAnotherDBA" <jadba_at_bellsouth.net> wrote in message news:a14X9.51459$Jm2.23170_at_news.bellsouth.net...
> 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 Wed Jan 22 2003 - 21:47:15 CST