Issues in comparing LOB data
ranjithv
Posts: 2
Hi Guys,
We are doing a migration of our database from EC2 to Oracle RDS, we have huge table with 41 million rows and 4 more tables with above 20 million rows, remaining all in small, we used oracle datapump utility to load data into Oracle RDS, We are able to compare all tables however we have some tables which have LOB data those tables are not able to compare at all. Please suggest if any settings needs to be done in tool to compare lob data.
Many Thanks
Ranjith
We are doing a migration of our database from EC2 to Oracle RDS, we have huge table with 41 million rows and 4 more tables with above 20 million rows, remaining all in small, we used oracle datapump utility to load data into Oracle RDS, We are able to compare all tables however we have some tables which have LOB data those tables are not able to compare at all. Please suggest if any settings needs to be done in tool to compare lob data.
Many Thanks
Ranjith
Comments
Please see the following article for an explanation of which data types can be compared:
http://documentation.red-gate.com/pages ... d=20185279
Is the one you can't compare on the list above? Are you able to just select the tables that have these LOB objects and see what it results in to?