Re: Replication using Snapshots

Hello Mate, Simon Here:

'rfgs1' refers to a refresh group named rfgs1.

This refresh group may either be created as a separate refresh group (named whatever you choose, normally something intuitive) into which several snapshots may be added

• OR -

'rfgs1' could be the name of a refresh group which was automatically created during the creation of the snapshot itself. (A create snapshot statement creates both a snapshot and a refresh group). You would have to remove the snapshot from the automatically generated refresh group in order to add it to another (more intuitively named) refresh group. At which point the empty refresh group is/may be dropped.

It can be advantageous to use logical refresh groups which represent a business requirement for frequency of data rather than separate refresh groups for each individualised snapshot.

HTH, Cheers,

Simon A.
Sr. Oracle DBA

"Rookie" <fake_at_fake.com> wrote in message news:<3eb90d94_at_shknews01>...
> To automatically update the snapshot
> call dbms_refresh.make('rfgs1','system.warehouse', sysdate,'sysdate+1/144')
>
>
> Could someone please tell me what is 'rfgs1' please? Is that just a name?
> thanks!
>
> call dmbs_refresh.make (?,?,?,?)
>
> What should I enter for each '?' thanks
Received on Wed May 07 2003 - 14:33:53 CDT