CHANGING CHARACTER SET

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Wed, 31 Oct 2001 08:45:16 -0800
Message-ID: <F001.003B9642.20011031090152@fatcity.com>

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: Harvinder.Singh_at_MetraTech.com

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: ListGuru_at_fatcity.com (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). Received on Wed Oct 31 2001 - 10:45:16 CST