Oracle 11gr2 - change character set from utf-8 to weiso8859p15
963972Jan 27 2013 — edited Jan 27 2013Hi guys,
I've a new and empty oracle 11gr2 database for my test environment, during the installation i've choosed the UTF-8 character's set but now i've see that in the production environment there is the WEISO8859 character's set.
I have a dump of the prod. env. (done with Exp function).
How can I change the character set from utf-8 to weiso8859p15 ?
I found this procedure:
SHUTDOWN IMMEDIATE or a SHUTDOWN NORMAL;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE NATIONAL CHARACTER SET new_character_set;
SHUTDOWN IMMEDIATE; -- or SHUTDOWN NORMAL;
STARTUP;
is it correct ?
Thx.
Kind Regards,
Stefano.