Re: NLS_LANG

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Mon, 03 Sep 2001 06:11:13 -0700
Message-ID: <F001.00380E54.20010903055022@fatcity.com>

Jan and Todd,

In Oracle8 and above this can be done provided you want to convert the db to a strict superset of the existing character set (e.g. US7ASCII to WE8ISO8859P1). Otherwise the only supported option is to recreate the db via export/import.

See the following metalink docs:

Note: 123670.1 "Use Scanner Utility before Altering the Database Character Set"
Note: 66320.1 "V8: Changing the Database National Character Set"
Note: 119164.1 "Changing Database Character set - Valid Superset definitions"

HTH,

• Anita --- Jan Pruner <jan_at_pruner.cz> wrote:
  > No way, only recreate the database.
  >
  > Jan Pruner
  >
  > Dne p?1. srpen 2001 18:08 jste napsal(a):
  > > Does anyone know how or if it is possible to
  > change the NLS_LANG value for
  > > a database that has already been created?
  > > I believe the answer is no, but I wanted a sanity
  > check (Lord knows I need
  > > one). Thanks.
  > >
  > > Todd Carlson
  > > Oracle 8i Certified DBA
  > > Bunge North America
  

  ---

Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Sep 03 2001 - 08:11:13 CDT