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.


-----Original Message-----
From: Jeffrey Beckstrom
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

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.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 4 | next ›
Discussion Overview
grouporacle-l @
postedJun 1, '04 at 9:28a
activeJun 1, '04 at 9:47a



site design / logo © 2022 Grokbase