RE: Changing character set

From: Vergara, Michael (TEM) <mvergara_at_guidant.com>
Date: Wed, 19 Nov 2003 13:05:09 -0800
Message-ID: <F001.005D730B.20031119130509@fatcity.com>

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: mkline1_at_comcast.net

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: 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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Vergara, Michael (TEM)
  INET: mvergara_at_guidant.com

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: 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 Nov 19 2003 - 15:05:09 CST