RE: export warning message on statistics
- From: "Vergara, Michael (TEM)" <mvergara@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 1 Jun 2004 07:48:28 -0700
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@xxxxxxxxx]
Sent: Tuesday, June 01, 2004 7: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.
Other related posts:
