| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Export 7.3.4 runs forever.
> Did you run dbv ?
dbv does not report any errors
> Does select count(*) from theTable; return a valid count ?
Table has 33827 rows. Correct as far as I can tell.
> What is the size of the table ?
Table has a LONG column. Almost every row should have data in it. I would
guess about 40MB or so total.
I would guess that I have a row where there is a bad pointer in the LONG coulmn, but I have no idea what to do about it.
Thanks,
"Ronald" <devnull_at_ronr.nl> wrote in message
news:67ce88e7.0202120219.1337a89b_at_posting.google.com...
> "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?
>
>
>
>
 |
 |