SUSPECT: RE: Quick and dirty way to compare table contents
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
- Date: Wed, 22 Feb 2006 16:04:54 -0500
I'm guessing you wouldn't have check everything. You should be able to
check 10-15% of the data to make a valid statistical conclusion that the
tables are the same or not the same. As far as the character data you
could probably transform it to numerical data and then summarize it.
Or, like some others said, export the data and do file comparison on the
export files.
-----Original Message-----
From: Ranko Mosic [mailto:ranko.mosic@xxxxxxxxx]
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/ContractSeniorOracleDBARankoMo
sicMain.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/ContractSeniorOracleDBARankoMo
sicMain.html
Other related posts:
