General
cancel
Showing results for 
Search instead for 
Did you mean: 

How to check the snapshot consistency?

Arturo Galbiati
Esteemed Contributor

How to check the snapshot consistency?

Hi,
I'd like to check the snapshot consistency between my master and slave databases (Oracle 9.2.0.6 aon HP-UX11.11) in term of data quality.
I.e.: not simply check that the shapshot run correctly and that the master and slave table has the same number of lines, but that the master and slave tables contains the same data.
Take note that my tables contains million of lines.
TIA,
ART
7 REPLIES
harry d brown jr
Honored Contributor

Re: How to check the snapshot consistency?


What kind of "snapshot" are we talking about?

You could export your production and your "snapshot" and diff them.

live free or die
harry d brown jr
Live Free or Die
HGN
Honored Contributor

Re: How to check the snapshot consistency?

Hi

I think this needs to be posted in a different place.

By snapshot are you trying to tell that you need copies of the tables,can those by exported to a file & compared.

Not sure if this is what you where looking for.

Rgds

HGN

Jean-Luc Oudart
Honored Contributor

Re: How to check the snapshot consistency?

Hi,

If I understand you've created a replication for some/all tables in the master database and you wonder if you can trust it even if the log tells you the refresh is sucesfull ?

This suggests that you will have to write your verification program/SQl script (sum & group) and diff the output. This supposes that the data in the master database is not altered while you run the verification process.
IS this for a once off or a process you want to run all the time ?

Regards
Jean-Luc
fiat lux
Arturo Galbiati
Esteemed Contributor

Re: How to check the snapshot consistency?

Hi Jean-Luc,
your assumptions are corrects.
I'd like to run this check regularly.
(i.e.:montly based)
Rgds,
Art
Indira Aramandla
Honored Contributor

Re: How to check the snapshot consistency?

Hi Arturo,

'Materialized view' and 'Snapshot' are synonymous as of 8i. A refresh synchronizes the MVIEW with it's master table.

Attached are two documents that explains the refresh mechanism.

I hope this helps

Indira A
Never give up, Keep Trying
Indira Aramandla
Honored Contributor

Re: How to check the snapshot consistency?

here is the other attachment.
Never give up, Keep Trying
Arturo Galbiati
Esteemed Contributor

Re: How to check the snapshot consistency?

thanks for teh suggestions.