How to check the snapshot consistency?

[Arturo Galbiati]

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

[harry d brown jr]

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

[HGN]

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]

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

[Arturo Galbiati]

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

[Indira Aramandla]

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

[Indira Aramandla]

here is the other attachment.

[Arturo Galbiati]

thanks for teh suggestions.