|
| 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_;
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_; |
|
| |
|
|
| |
|
Free