RE: Migrating from 7 to 9i

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Fri, 09 Aug 2002 07:58:24 -0800
Message-ID: <F001.004B089B.20020809075824@fatcity.com>

Thanks Dennis for a beautiful reply....

Anyways, since I have been pushed into unknown territory(Oracle 7) on which I have never worked before, I can't go home and sleep that early :-)

The downtime will not be a problem.

I'm yet to see the database, but will be working on the migration pretty soon. But the thing which i'm worried about the most is not the migration from version 7 to 9i, its the corresponding character set conversion which will really test me, and also my lack of experience(maybe).

My concern is how to ensure the data correctness after the conversion. All I have been mailed to me is that :
<mailed to me>
There are few tables which store Chinese Characters. And it also requires converting Big5 internal code (some are HK characters set) into Unicode ISO10646:1-2000
</mailed to me>

Now even after searching on Google, I don't understand what "Big5 internal code (some are HK characters set)" means.

I understand that due to incompatibility of Character sets there maybe issues like data truncation and data corruption, but is it true that if the conversion is to Unicode, this should not happen?

In case, it happens how to ensure that the data is complete and correct. I can inmport the data to flat files and write some code to compare the data, but are there any tools available.

I have enough documentation, but not enough experience so if you experienced people want to share anything which I may miss out, I'll appreciate it.

And ya, sorry for a long mail.

Regards,
Naveen
--

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

Author: Naveen Nahata
  INET: naveen_nahata_at_mindtree.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 Fri Aug 09 2002 - 10:58:24 CDT