ALTER DATABASE CHARACTER SET WE8MSWIN1252

Jan 30, 2017 10:51AM

Hi,

Is it possible to change to character set to WE8MSWIN1252? I have WE8ISO8859P15 installed on an Oracle 12c: NLS_CHARACTERSET=WE8ISO8859P15.

If so, would the procedure below be correct/complete?

--logged on with sys as sysdba

SHUTDOWN IMMEDIATE;

STARTUP RESTRICT;

ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

ALTER SYSTEM SET AQ_TM_PROCESSES=0;

ALTER DATABASE CHARACTER SET WE8MSWIN1252;

SHUTDOWN IMMEDIATE;

STARTUP;

Would Migrating Character Data Using a Full Export and Import + Migrating a Character Set Using the CSALTER Script as stated below be needed?

Database Administration (MOSC)