Re: Export 7.3.4 runs forever.

"AndyS" <AndySnospam_at_IAnospamSystems.com> wrote in message news:<bhY98.905$A%3.15043_at_ord-read.news.verio.net>...
> I should have mentioned that this is on NT.
>
> "AndyS" <AndySnospam_at_IAnospamSystems.com> wrote in message
> news:K0Y98.904$A%3.14805_at_ord-read.news.verio.net...
> > I am trying to migrate a 7.3.4 database to 8.1.6 via Export/Import. Export
> > seems to get into a loop processing one particular table. I can export
> every
> > other table with out a problem. On this one table Export will run forever
> > and consume all available disk. Running ANALYZE TABLE VALIDATE STRUCTURE
> > gives an error until I remove all defined indexes on that table. Then no
> > ANALYZE error, but Export still loops. Anybody ever seen something like
> this
> > before? Any ideas?

Andy,

Did you run dbv ?
Does select count(*) from theTable; return a valid count ? What is the size of the table ?

You might have a corrupted datafile. If you can identify the block you could select the rows around that block into a temporary table and continue with that one. Asuming this error is in the database for ages making backup/recovery very hard or timeconsuming.

Ronald.