Database Administration (MOSC)

MOSC Banner

Want to change CHARACTER SET of a production database

edited Oct 25, 2024 4:13PM in Database Administration (MOSC) 4 commentsAnswered ✓

Our production database has NLS_CHARACTERSET WE8ISO8859P15. Before we upgrade next application version (Automic), the vendor has asked us to change database

NLS_CHARACTERSET from WE8ISO8859P15 to AL32UTF8.

If we execute:

SHUTDOWN IMMEDIATE;
STARTUP RESTRICT;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 0
/
ALTER SYSTEM SET AQ_TM_PROCESSES = 0
/
ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8
/
SHUTDOWN IMMEDIATE;
STARTUP;

Will it work? Is it a recommended path?

Thanks,

Unmesh

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center