Title: RE: Converting from ASCII7 to UTF8
This can be done pretty easily using SharePlex for Oracle. It's able to replicate between different character sets, platforms, DB versions.. It can also handle your long columns as well.
As for the concern of database space... you'll probably gain back a lot of space, since you'll eventually be doing an import/export of the database... any fragmentation of the tables or indexes will be removed. You could even partition/index the tables differently to take advantage of the reports that are run to help optimize the system.
It's even been used to convert db's from single-byte to multi-byte as well.
www.quest.com/shareplex
hth
Nick
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 6:50 AM
To: Multiple recipients of list ORACLE-L
Subject: Converting from ASCII7 to UTF8
We are planning on converting our 240-Gig data warehouse (will be 8.1.7.2
on Sun Solaris 2.6)
from character set ASCII7 to UTF8.
Has anybody had any experience in doing this? If you have, what pitfalls,
problems, etc. did
you encounter? Anything that we need to watch out for? What about
longs?
A particular concern for our database owners is whether this conversion
will increase the size
of the database. Anybody know of any anecdotal evidence either way?
Thanks,
Cherie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).