CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle NLS Character Sets
Version 11.1
 
Demo

Changing Character Sets
Note: Depending on the character sets involved this may result in data loss. Try this in test environments before proceeding in production.
conn / as sysdba

col parameter format a30
col value format a30

SELECT view_name
FROM dba_views
WHERE view_name LIKE '%NLS%';

SELECT *
FROM gv_$nls_parameters;

SHUTDOWN IMMEDIATE;
STARTUP RESTRICT;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;

ALTER DATABASE CHARACTER SET WE8MSWIN1252;

-- if the above fails:
ALTER DATABASE CHARACTER SET INTERNAL_USE WE8MSWIN1252;
SHUTDOWN IMMEDIATE;
STARTUP;

SELECT *
FROM gv_$nls_parameters;
 
Related Topics
Character Set Functions
UTL_GDK
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [112 users online]    © 2010 psoug.org