OraFAQ Forum: Server Administration » Change of character set in Oracle 8

Home » RDBMS Server » Server Administration » Change of character set in Oracle 8

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Change of character set in Oracle 8 [message #61289]

Mon, 12 April 2004 21:30

CC Su
Messages: 4
Registered: April 2004

Junior Member

Hello,

If the database is installed with the WE8DEC character set,can we convert it to US7ASCII character set?

Thks & Best regards,

�

�

Report message to a moderator

Re: Change of character set in Oracle 8 [message #61301 is a reply to message #61289]

Tue, 13 April 2004 08:40

Thiru
Messages: 1089
Registered: May 2002

Senior Member

WE8DEC is a superset of US7ASCII and hence you may need to employ export/import to change the character set , from We8DEC to US7ASCII(but again you will need to take care of any truncation)

For details : Character set conversion

-Thiru

Report message to a moderator

Re: Change of character set in Oracle 8 [message #61313 is a reply to message #61301]

Tue, 13 April 2004 18:39

CC Su
Messages: 4
Registered: April 2004

Junior Member

Hi Thiru,

So I cannot use following procedure to change character set from WE8DEC to US7ASCII.

1. SVRMGR> CONNECT INTERNAL
2. SVRMGR> SHUTDOWN IMMEDIATE
3. SVRMGR> STARTUP MOUNT
4. SVRMGR> ALTER SYSTEM ENABLE RESTRICTED SESSION;
5. SVRMGR> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
6. SVRMGR> ALTER DATABASE OPEN;
7. SVRMGR> ALTER DATABASE CHARACTER SET US7ASCII;
8. SVRMGR> SHUTDOWN IMMEDIATE
9. SVRMGR> EXIT
10. Adjust NLS_LANG in the environment

Thks & Best Regards,

Report message to a moderator