Script to compare the table data between two oracle schemas (merged) [message #426049] |
Wed, 14 October 2009 00:22 |
gokul_ifs
Messages: 41 Registered: March 2006 Location: india
|
Member |
|
|
Hi,
I would like to compare the table data between two oracle schemas.
Both the schemas contains almost identical database objects.
Kindly share if you have any SQL or shell script for this.
I would not prefer to use tools like TOAD or SQL developer, as this comparison process needs to be automated in my application.
Thanks,
SAMURAI
|
|
|
|
|
Script to compare the table data between two oracle schemas [message #426092 is a reply to message #426049] |
Wed, 14 October 2009 01:24 |
gokul_ifs
Messages: 41 Registered: March 2006 Location: india
|
Member |
|
|
Hi,
I would like to compare the table data between two oracle schemas.
Both the schemas contains almost identical database objects.
Kindly share if you have any SQL or shell script for this.
I would not prefer to use tools like TOAD or SQL developer, as this comparison process needs to be automated in my application.
Note: My prime focus is to compare only data. Not to compare table definition.
Thanks,
SAMURAI
|
|
|
|
|
|
|