Re: Quick and dirty way to compare table contents
- From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
- To: dofreeman@xxxxxxxxxxx
- Date: Wed, 22 Feb 2006 15:49:14 -0500
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/ContractSeniorOracleDBARankoMosicMain.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/ContractSeniorOracleDBARankoMosicMain.html
Other related posts:
