Database Administration (MOSC)

MOSC Banner

How to Change Database Characterset Using Template

edited Sep 27, 2011 4:34PM in Database Administration (MOSC) 2 commentsAnswered
 Hi Folks
Using 10.2.0.5 RDBMS on Windows 2003

I need to change the NLS_CHARACTERSET when i create a database using a template
vbut i doi not see where i have the opportunity to do so in Database Configuratin Assistant

Anyone know where I would make the change

current settings; need to change to AL32UT8

select * from nls_database_parameters where parameter like '%CHARACTERSET';

PARAMETER                                    VALUE
------------------------------                ----------------------------------------
NLS_CHARACTERSET                    WE8MSWIN1252
NLS_NCHAR_CHARACTERSET      AL16UTF16

Thanks
Jim

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