DOA & Snapshots

[DaveH]

Is it possible, using any of the DOA Components, to force a refresh of a snapshot or refresh group? If so, could you please give a code example to a dummy?

TIA
DaveH

 

[Marco Kalter]

To refresh a snapshot, create a TOraclePackage instance called 'DbmsSnapshot', set its PackageName property to 'dbms_refresh', link it to a session, and call it like this in your Delphi application:

DbmsSnapshot.CallProcedure('refresh', ['mysnapshot']);

This procedure has lots of optional parameters, check out the Replication API Reference manual for details. To refresh a group, create a package called 'DbmsRefresh', set its PackageName property to 'dbms_refresh', and call it like this:

DbmsRefresh.CallProcedure('refresh', ['myrefreshgroup']);

------------------
Marco Kalter
Allround Automations

 

[DaveH]

Thank you... I will certainly try that tonight!

Dave