EXP-00091 Exporting Questionable Statistics

Today, perform a export (old system, Oracle Version 9.2), of course, it is out of support, I have received this warning. It is a classical or typical error.

Whe you run execute the older exp

 

exp userid=X file=x.dat log=x.log owner=x buffer=1048576000

 

You can received one or several warnings like this

. . exporting table STATS$UNDOSTAT^C

EXP-00091 Exporting Questionable Statistic

. . exporting table STATS$WAITSTAT

 

There a two easy ways to solve this.

 

  • export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1    The character set and lenguage is depend on your system. It is important OS, in this case is a Solaris 10, because this variable is setting at level operating system.
  • exp userid=X file=x.dat log=x.log owner=x buffer=1048576000 statistics=none                                        In this case have executed exp with statistics parameter

 

HTH – Antonio NAVARRO

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s