From oracle-l-bounce@freelists.org Tue Jun 1 09:47:59 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i51EliH22247 for ; Tue, 1 Jun 2004 09:47:54 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i51ElY622220 for ; Tue, 1 Jun 2004 09:47:44 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6549272C3AF; Tue, 1 Jun 2004 09:34:24 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15735-41; Tue, 1 Jun 2004 09:34:23 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1939572C84F; Tue, 1 Jun 2004 09:34:18 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 01 Jun 2004 09:32:49 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 146D672C7FB for ; Tue, 1 Jun 2004 09:32:49 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15106-71 for ; Tue, 1 Jun 2004 09:32:48 -0500 (EST) Received: from gcrta.org (clevelandrta.org [209.49.247.27]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 97AEF72C89A for ; Tue, 1 Jun 2004 09:32:14 -0500 (EST) Received: from GWIA_DOM-MTA by gcrta.org with Novell_GroupWise; Tue, 01 Jun 2004 10:50:18 -0400 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.0 Date: Tue, 01 Jun 2004 10:50:10 -0400 From: "Jeffrey Beckstrom" To: Subject: RE: export warning message on statistics Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=_B99848BA.C5A4CE99" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1697 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: JBECKSTROM@gcrta.org Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org --=_B99848BA.C5A4CE99 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit thanks >>> dofreeman@state.pa.us 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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Jeffrey Beckstrom Sent: Tuesday, June 01, 2004 10:30 AM To: oracle-l@freelists.org; ORACLE-L@IC.SUNYSB.EDU; oracledba@lazydba.com; oracle-rdbms@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. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 --=_B99848BA.C5A4CE99 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Description: HTML thanks

>>> dofreeman@state.pa.us 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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Jeffrey Beckstrom
Sent: Tuesday, June 01, 2004 10:30 AM
To: oracle-l@freelists.org; ORACLE-L@IC.SUNYSB.EDU; oracledba@lazydba.com; oracle-rdbms@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.

 
 
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
--=_B99848BA.C5A4CE99-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------