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