Database Networking (MOSC)

MOSC Banner

ORA-12514 ORA-12528 - Trying a ALTER DATABASE CHARACTER SET

edited Jul 14, 2018 5:01AM in Database Networking (MOSC) 13 commentsAnswered
  10.2.0.1.0, Windows 2000,
Actually I wanted to
alter database character set WE8MSWIN1252;
	


following a recipe I found in some Wiki http://de.wikibooks.org/wiki/Oracle:_CharacterSet_ändern

sqlplus "sys/password@myDB as sysdba"
select value from nls_database_parameters where parameter='NLS_CHARACTERSET';
select * from nls_database_parameters;
shutdown immediate;
startup mount;
alter system enable restricted session;
alter system set job_queue_processes=0;
alter database character set UTF8;
ORA-12712: Der neue Zeichensatz muss eine Obermenge des alten Zeichensatzes
sein
alter database character set internal_use utf8;
shutdown immediate;
startup;
select * from nls_database_parameters;

(In my case I want to change an instance from UTF8 to WE8MSWIN1252, hoping it would work also the other way around)

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