FreeLists / oracle-l / RE: export warning message on statistics

["Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>]

thanks

>>> dofreeman@xxxxxxxxxxx 6/1/04 10:36:48 AM >>>
You can set the language you want to export in.  We are using export
scripts and insert the following as the first line:
 
SET NLS_LANG=American_america.US7ASCII
 
You won't get the warnings if you export in a compatible language.
 
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jeffrey Beckstrom
Sent: Tuesday, June 01, 2004 10:30 AM
To: oracle-l@xxxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxxxx;
oracledba@xxxxxxxxxxx; oracle-rdbms@xxxxxxxxxxxxxxx 
Subject: export warning message on statistics


Using Oracle 9.2.0.5.
 
Doing interactive export, i.e. letting myself get prompted for
parameters. I get a message about exporting questionable statistics. I
presume this is due to the following message:
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character
set
server uses WE8ISO8859P1 character set (possible charset conversion)

How can I get rid of the "export terminated with warning" message?
 
If on the command line I add statistions=none, then I don't get
prompted for the export parameters at all so that doesn't help.

 
 
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113