Oracle EXP-00091 Error When Export Database

Resolving The Problem

After FCM upgrade from 4.0 to 4.0.1, you may experience EXP-00091 errors during OPBackup which causes only OpenPages schema to be backed up. There is no ZIP file created at the end which is a problem.

The cause for this error is because statistics may not be useable although Export was able to export statistics. The statistics are questionable because one or more of the following happened during export:

A row error occurred
Client character set or NCHARSET (where you run the Export) does not match with the server (database character set)
A query clause was specified on export, only certain partitions or subpartitions were exported
A fatal error occurred while processing a table

A easy way of resolution -
export with option “STATISTICS=NONE”.
It’s pretty safe to say that if EXP-00091 is the only error message, the export’s row data is without any problems. If desired, import parameters can be supplied so that only non-questionable statistics will be imported, and all questionable statistics will be recalculated.


Also, set the NLS_LANG environment variable at the OS level, prior to the export session, to match your database character set. Syntax as follow, change the character set to your database’s character set.

export NLS_LANG=AL32UTF8

However setting the NLS_LANG to the character set of the database MAY be correct but IS often not correct. DO NOT assume that NLS_LANG needs to be the same as the database character set. THIS IS OFTEN NOT TRUE. So we would strongly suggust you try export with option “STATISTICS=NONE”.

What you should do is to replace all the

CONSISTENT=Y
to
STATISTICS=NONE

in op-sox-backup-recovery.xml