| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: export warning message on statistics
Jeffrey:
The statistics warning has nothing to do with the database/client character set. It's telling you that the statistics you are exporting may not be correct when you import.
You have two choices. You can not export the statistics or not import the statistics. The only way to not export statistics is with the statistics=none parameter, and if you use ANY command-line parameters then exp does not prompt, so you must either use a parameter file of place all the information on the command line.
Or you can import with statistics=none and the statistics in the DMP file will be ignored.
Cheers,
Mike
-----Original Message-----
From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org]
Sent: Tuesday, June 01, 2004 7:30 AM
To: oracle-l_at_freelists.org; ORACLE-L_at_IC.SUNYSB.EDU; oracledba_at_lazydba.com; oracle-rdbms_at_yahoogroups.com
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.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Tue Jun 01 2004 - 09:46:28 CDT
-----------------------------------------------------------------
 |
 |