Re: Changing Character Set from WE8ISO8859P1 to UTF8
You can't change to UTF8 from WE8ISO8859P1, since the latter is not a subset of UTF8. If you were on US7ASCII, the story would be different. You have to go with export/import. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, December 14, 2003 6:19 AM I have upgraded the database from 8.0.5/8.1.7 to 9.2.0.4 and changed character set using alter database character set. It will work without any problem. Go for it. -Original Message- Sent: Saturday, December 13, 2003 9:39 PM To: Multiple recipients of list ORACLE-L I am in the process of planning our upgrade for our 8.1.5 database to 8.1.7.4. This is the first step in upgrading all my databases to 9.2.0.4. As part of this upgrade I am changing the character set from WE8ISO8859P1 to UTF8. Has anyone done this change using the ALTER DATABASE CHARACTER SET command? If so, was there any problems? Thanks, Sandra Arnold Principal DBA NCI Information Systems -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arnold, Sandra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pandian, Thiru INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Changing Character Set from WE8ISO8859P1 to UTF8
Oracle has an internal utility to do this in place named csconv. You have to get this from Oracle consulting. In any event, there is a utility named csscan in your oracle home. Run it against your database and it will tell what data if any needs to be changed. Look for UTF8 conversion docs on metalink. They have what you need there. A direct conversion using the alter database commnad will corrupt data if not everyting in your database is convertible. You must do this to do the export import cycle or cssconv. Allan -Original Message- Tanel Poder Sent: Monday, December 15, 2003 4:54 AM To: Multiple recipients of list ORACLE-L You can't change to UTF8 from WE8ISO8859P1, since the latter is not a subset of UTF8. If you were on US7ASCII, the story would be different. You have to go with export/import. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, December 14, 2003 6:19 AM I have upgraded the database from 8.0.5/8.1.7 to 9.2.0.4 and changed character set using alter database character set. It will work without any problem. Go for it. -Original Message- Sent: Saturday, December 13, 2003 9:39 PM To: Multiple recipients of list ORACLE-L I am in the process of planning our upgrade for our 8.1.5 database to 8.1.7.4. This is the first step in upgrading all my databases to 9.2.0.4. As part of this upgrade I am changing the character set from WE8ISO8859P1 to UTF8. Has anyone done this change using the ALTER DATABASE CHARACTER SET command? If so, was there any problems? Thanks, Sandra Arnold Principal DBA NCI Information Systems -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arnold, Sandra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pandian, Thiru INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Changing Character Set from WE8ISO8859P1 to UTF8
I have upgraded the database from 8.0.5/8.1.7 to 9.2.0.4 and changed character set using alter database character set. It will work without any problem. Go for it. -Original Message- Sent: Saturday, December 13, 2003 9:39 PM To: Multiple recipients of list ORACLE-L I am in the process of planning our upgrade for our 8.1.5 database to 8.1.7.4. This is the first step in upgrading all my databases to 9.2.0.4. As part of this upgrade I am changing the character set from WE8ISO8859P1 to UTF8. Has anyone done this change using the ALTER DATABASE CHARACTER SET command? If so, was there any problems? Thanks, Sandra Arnold Principal DBA NCI Information Systems -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arnold, Sandra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pandian, Thiru INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Changing character set
There's a whole spread of stuff on MetalLink about changing character sets. There is even a utility program called 'csscan' that scans the DB to find potential trouble spots. In short, though, if this DB only has 7-bit ASCII characters in in, then a switch to UTF-8 will have no immediate effect. Cheers, Mike -Original Message- Sent: Wednesday, November 19, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Anyone change character sets recently? I've got a cust that wants to take a small database from US7ASCII to UTF8 I believe it was. It sounds like they have all the steps down pat and are pretty much ready to go, but are there any gotchas they may have missed? Will this affect the RMAN backups they get nightly? I've told them to do a cold file backup first, then try on test, and if all is cool they can proceed... 20 years working with Oracle and this is a first time for me. Web interface on this note, so I hope it comes out okay... -- 13308 Thornridge Ct Midlothian, VA 23112 804-744-1545 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CHANGING CHARACTER SET
Gerardo, The trick works for me also but when i try to export it shows as: Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Export done in US7ASCII character set and US7ASCII NCHAR character set server uses UTF8 character set (possible charset conversion) Do we are able to change character set or our existing data is still using US7ASCII. Thanks -Harvinder -Original Message- Sent: Thursday, November 01, 2001 2:00 AM To: Multiple recipients of list ORACLE-L Try this procedure: The extra db bounce did the trick for me. Don't ask me why. I think I found it on MetaLink or opened a TAR. HTH Gerardo SVRMGR SHUTDOWN IMMEDIATE; -- or NORMAL do a full database backup SVRMGR STARTUP MOUNT; SVRMGR ALTER SYSTEM ENABLE RESTRICTED SESSION; SVRMGR ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SVRMGR ALTER SYSTEM SET AQ_TM_PROCESSES=0; SVRMGR ALTER DATABASE OPEN; SVRMGR ALTER DATABASE CHARACTER SET new_character_set; SVRMGR SHUTDOWN IMMEDIATE; SVRMGR STARTUP RESTRICT; SVRMGR SHUTDOWN IMMEDIATE; SVRMGR STARTUP; -Original Message- Sent: Wednesday, October 31, 2001 9:02 AM To: Multiple recipients of list ORACLE-L Hi, We are planning to change out database charater set from US7ASCII to UTF8 and we followed folowing steps as specified in metalink... but still when i see the trace of controlfile it shows character set as US7ASCII.. Do i need to do export/import to change takes place. we have oracle 8.1.7.1.5 on WIN2K. SVRMGR SHUTDOWN IMMEDIATE; -- or NORMAL do a full database backup SVRMGR STARTUP MOUNT; SVRMGR ALTER SYSTEM ENABLE RESTRICTED SESSION; SVRMGR ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SVRMGR ALTER SYSTEM SET AQ_TM_PROCESSES=0; SVRMGR ALTER DATABASE OPEN; SVRMGR ALTER DATABASE CHARACTER SET new_character_set; SVRMGR SHUTDOWN IMMEDIATE; -- OR NORMAL SVRMGR STARTUP; Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CHANGING CHARACTER SET
Harvinder, try setting NLS_LANG=AMERICAN_AMERICA.UTF8, then doing the export. If NLS_LANG is not set, the default is US7ASCII as you experienced. Refer to MetaLink Note 48644.1 and Note 15095.1 Gerardo -Original Message- Sent: Thursday, November 01, 2001 7:30 AM To: Multiple recipients of list ORACLE-L Gerardo, The trick works for me also but when i try to export it shows as: Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Export done in US7ASCII character set and US7ASCII NCHAR character set server uses UTF8 character set (possible charset conversion) Do we are able to change character set or our existing data is still using US7ASCII. Thanks -Harvinder -Original Message- Sent: Thursday, November 01, 2001 2:00 AM To: Multiple recipients of list ORACLE-L Try this procedure: The extra db bounce did the trick for me. Don't ask me why. I think I found it on MetaLink or opened a TAR. HTH Gerardo SVRMGR SHUTDOWN IMMEDIATE; -- or NORMAL do a full database backup SVRMGR STARTUP MOUNT; SVRMGR ALTER SYSTEM ENABLE RESTRICTED SESSION; SVRMGR ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SVRMGR ALTER SYSTEM SET AQ_TM_PROCESSES=0; SVRMGR ALTER DATABASE OPEN; SVRMGR ALTER DATABASE CHARACTER SET new_character_set; SVRMGR SHUTDOWN IMMEDIATE; SVRMGR STARTUP RESTRICT; SVRMGR SHUTDOWN IMMEDIATE; SVRMGR STARTUP; -Original Message- Sent: Wednesday, October 31, 2001 9:02 AM To: Multiple recipients of list ORACLE-L Hi, We are planning to change out database charater set from US7ASCII to UTF8 and we followed folowing steps as specified in metalink... but still when i see the trace of controlfile it shows character set as US7ASCII.. Do i need to do export/import to change takes place. we have oracle 8.1.7.1.5 on WIN2K. SVRMGR SHUTDOWN IMMEDIATE; -- or NORMAL do a full database backup SVRMGR STARTUP MOUNT; SVRMGR ALTER SYSTEM ENABLE RESTRICTED SESSION; SVRMGR ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SVRMGR ALTER SYSTEM SET AQ_TM_PROCESSES=0; SVRMGR ALTER DATABASE OPEN; SVRMGR ALTER DATABASE CHARACTER SET new_character_set; SVRMGR SHUTDOWN IMMEDIATE; -- OR NORMAL SVRMGR STARTUP; Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CHANGING CHARACTER SET
NLS_LANG should be set on client, either UNIX environment variable or NT registry entry. I don't think there's a way to force client to use a particular character set. This is the whole point of NLS, I think. Server should not care what language/character set client uses, and vice versa. Gerardo -Original Message- Sent: Thursday, November 01, 2001 10:27 AM To: 'Molina, Gerardo' Gerardo, Thanks for your help. I need little more clarification: When we change the database character set from US7ASCII TO UTF8 Do this will only affects for the server database and client can still export in different character set as per setting of NLS_LANG on their machine.. If i want to force clients to use NLS_LANG of server database how can i set some parameters on server . NLS_LANG is set as environment varable but if i want to add entry in init.ora we have parameter NLS_LANGUAGE and NLS_TERRITORY...but how can we specify the chacter set in init.ora file I know i am asking some silly questions but i am totally confused with oracle docs. Thanks -Harvinder -Original Message- Sent: Thursday, November 01, 2001 11:40 AM To: Multiple recipients of list ORACLE-L Harvinder, try setting NLS_LANG=AMERICAN_AMERICA.UTF8, then doing the export. If NLS_LANG is not set, the default is US7ASCII as you experienced. Refer to MetaLink Note 48644.1 and Note 15095.1 Gerardo -Original Message- Sent: Thursday, November 01, 2001 7:30 AM To: Multiple recipients of list ORACLE-L Gerardo, The trick works for me also but when i try to export it shows as: Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Export done in US7ASCII character set and US7ASCII NCHAR character set server uses UTF8 character set (possible charset conversion) Do we are able to change character set or our existing data is still using US7ASCII. Thanks -Harvinder -Original Message- Sent: Thursday, November 01, 2001 2:00 AM To: Multiple recipients of list ORACLE-L Try this procedure: The extra db bounce did the trick for me. Don't ask me why. I think I found it on MetaLink or opened a TAR. HTH Gerardo SVRMGR SHUTDOWN IMMEDIATE; -- or NORMAL do a full database backup SVRMGR STARTUP MOUNT; SVRMGR ALTER SYSTEM ENABLE RESTRICTED SESSION; SVRMGR ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SVRMGR ALTER SYSTEM SET AQ_TM_PROCESSES=0; SVRMGR ALTER DATABASE OPEN; SVRMGR ALTER DATABASE CHARACTER SET new_character_set; SVRMGR SHUTDOWN IMMEDIATE; SVRMGR STARTUP RESTRICT; SVRMGR SHUTDOWN IMMEDIATE; SVRMGR STARTUP; -Original Message- Sent: Wednesday, October 31, 2001 9:02 AM To: Multiple recipients of list ORACLE-L Hi, We are planning to change out database charater set from US7ASCII to UTF8 and we followed folowing steps as specified in metalink... but still when i see the trace of controlfile it shows character set as US7ASCII.. Do i need to do export/import to change takes place. we have oracle 8.1.7.1.5 on WIN2K. SVRMGR SHUTDOWN IMMEDIATE; -- or NORMAL do a full database backup SVRMGR STARTUP MOUNT; SVRMGR ALTER SYSTEM ENABLE RESTRICTED SESSION; SVRMGR ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SVRMGR ALTER SYSTEM SET AQ_TM_PROCESSES=0; SVRMGR ALTER DATABASE OPEN; SVRMGR ALTER DATABASE CHARACTER SET new_character_set; SVRMGR SHUTDOWN IMMEDIATE; -- OR NORMAL SVRMGR STARTUP; Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
RE: CHANGING CHARACTER SET
Try this procedure: The extra db bounce did the trick for me. Don't ask me why. I think I found it on MetaLink or opened a TAR. HTH Gerardo SVRMGR SHUTDOWN IMMEDIATE; -- or NORMAL do a full database backup SVRMGR STARTUP MOUNT; SVRMGR ALTER SYSTEM ENABLE RESTRICTED SESSION; SVRMGR ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SVRMGR ALTER SYSTEM SET AQ_TM_PROCESSES=0; SVRMGR ALTER DATABASE OPEN; SVRMGR ALTER DATABASE CHARACTER SET new_character_set; SVRMGR SHUTDOWN IMMEDIATE; SVRMGR STARTUP RESTRICT; SVRMGR SHUTDOWN IMMEDIATE; SVRMGR STARTUP; -Original Message- Sent: Wednesday, October 31, 2001 9:02 AM To: Multiple recipients of list ORACLE-L Hi, We are planning to change out database charater set from US7ASCII to UTF8 and we followed folowing steps as specified in metalink... but still when i see the trace of controlfile it shows character set as US7ASCII.. Do i need to do export/import to change takes place. we have oracle 8.1.7.1.5 on WIN2K. SVRMGR SHUTDOWN IMMEDIATE; -- or NORMAL do a full database backup SVRMGR STARTUP MOUNT; SVRMGR ALTER SYSTEM ENABLE RESTRICTED SESSION; SVRMGR ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SVRMGR ALTER SYSTEM SET AQ_TM_PROCESSES=0; SVRMGR ALTER DATABASE OPEN; SVRMGR ALTER DATABASE CHARACTER SET new_character_set; SVRMGR SHUTDOWN IMMEDIATE; -- OR NORMAL SVRMGR STARTUP; Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).