Re: EXP-00091 on 9i EXPORT ( user )

Rob Williamson wrote:

> Oracle 9i)Doing a user export I got this error on the tables only and
> sometimes two errors per table. The import into a new 9i db (we are
> recreating the development DB for production ) works fine and the apps
> seem to work and the number of rows imported and exported match. But we
> did get an error. This is a test import export and I would like to know
> what this means for future trouble possibilities if there are any.
>

[...]
>
> I have eliminated the query clause problem becuase we used no query
> in the export and I believe the partition explanation is not an option
> either but I am not completely sure. What can I do to verify that it is
> NCHARSET issue or row error occured. If all rows exported I would like
> to assume that row error is not an issue either?
>
> Any Help
>
> Rob
>

Simplest approach is to export with STATISTICS=NONE option and just regenerate statistics in the target database after the import.

You could try setting the NLS_LANG environment variable at the OS level, prior to the export session, to match your database character set to see if that is the exact cause (probably a good idea anyway, as you will get some warnings otherwise).

It's pretty safe to say that if this is your only error message, your row data is coming across without any problems.

-Mark Bole Received on Mon Nov 15 2004 - 11:42:50 CST