Re: Export 7.3.4 runs forever.

"AndyS" <AndySnospam_at_IAnospamSystems.com> wrote:

>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.

Have you also disabled all constraints? Seeing that the indexes contributed to the problem, it may make sense to make this table buck naked without anything but data.

Try creating a copy of the table using a CREATE TABLE with an unrecoverable SELECT.

If that does not work, you can then try to recover the data that is recoverable. Run a CREATE TABLE again, but limit the columns (e.g. do not include the long), or limit the data set processed using a WHERE clause (processing the problem table in chunks).

If really want to trace the problem to a possible row that is the cause, consider creating a reference/work table containing rownum and rowids from the source (33827 rows are fairly small). Run a join on rowid between these two tables, using rownum in the ref table to process something like 10 rows at a time, looking for the 10 row block(s) that fail a select or an export.

It could also be something as simple as re-running the catexp script because the data dictionary is no longer kosher or halaal. :-)

If the selects work and the exp still does not, consider a db link and pulling the data into a newer version Oracle db that way. Or export (using SQL*Plus or a quick and dirty custom Delphi app) the data into CSV and the longs into binary files.

BTW, Delphi also has (or used to have) a component that allowed for the copying of tables between heterogenous databases (i.e. copying the data down to the client and then pushing it up to the destination db).

Use MS Access to copy that table to a local Access table and see if that works.

Come on Andy, there are loads of ideas to try if you put half a mind to it. :-)

--
Billy