RE: Quick and dirty way to compare table contents
- From: "Vadim Bobrov" <vadimbobrov@xxxxxxxxx>
- To: <ranko.mosic@xxxxxxxxx>, <dofreeman@xxxxxxxxxxx>
- Date: Wed, 22 Feb 2006 15:54:16 -0500
Export both tables to different files and then checksum the files. You might
need to edit the files before checksumming though...
Vadim Bobrov
Oracle Database Tools
http://www.fourthelephant.com
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Ranko Mosic
Sent: Wednesday, February 22, 2006 3:49 PM
To: dofreeman@xxxxxxxxxxx
Cc: _oracle_L_list
Subject: Re: Quick and dirty way to compare table contents
Yes, I am thinking about applying some function to all the data.
Maybe summarize all numerical columns. I don't know what to do with
character columns.
On 2/22/06, Freeman, Donald <dofreeman@xxxxxxxxxxx> wrote:
Sounds like you need a way to hash the whole table and compare the hash
results. I bet you could write a little procedure to do that.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Ranko Mosic
Sent: Wednesday, February 22, 2006 2:40 PM
To: _oracle_L_list
Subject: Quick and dirty way to compare table contents
Hi list,
I need to quckly compare tables in 2 schemas to verify contents are
identical.
Counting blocks/rows, using tools to compare schemas is not possible.
Something similar to checksum mechanism is requested. Any ideas ?
--
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr@xxxxxxxxxx
http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicM
ain.html
<http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosic
Main.html>
--
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr@xxxxxxxxxx
http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicM
ain.html
Other related posts:
