Hi Experts,
I am upgrading my database version from 10.2.0.1.0 to 11.2.0.4.0.
(We are creating a new instance with v11.2, taking db dump from v 10g and copying it into new one. This is done to keep the 10g database still active, until the new one gets stabilized. Later we will decommission it.)
After this change, I want to compare and validate that every bit of data is same and nothing has got changed (corrupted).
Last week, there was an issue reported by our DBA that some Espanol characters (using Latin characters) requires 2 or 3 bytes for storage in UTF-8, were not able to fit into the existing table columns. In short, some NLS related problems are creeping in.
Is there any technique to hash a table in both the environments and do comparison? Please assist with some ideas.
Thanks and Regards,
-Ranit