| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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: Cherie_Machler_at_gelco.com [mailto:Cherie_Machler_at_gelco.com]
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: Cherie_Machler_at_gelco.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 Dec 19 2001 - 11:55:35 CST
 |
 |