JamesLane <JamesLane03@ya hoo.comwrote in message news:<3042319.1 056559068@dbfor ums.com>...
No. You are tearing things out of context. Using this procedure you
effectively *disable* replication. I found out by just searching on
'I_AM_A_REFRESH ' on tahiti.oracle.c om
Also this function is likely not available in older versions.
Please try getting the full picture of replication. It is much less
simple than you seem to think.
Sybrand Bakker
Senior Oracle DBA
I read in an Oracle manual:
>
To disable all local replication triggers for snapshots at your current
site, set the internal refresh variable to TRUE by calling
SET_I_AM_A_REFR ESH, as shown in the following example:
>
DBMS_SNAPSHOT.S ET_I_AM_A_REFRE SH(value =TRUE);
>
Once again, please remember i'm still very new at Oracle, but would this
script be my answer?
>
To disable all local replication triggers for snapshots at your current
site, set the internal refresh variable to TRUE by calling
SET_I_AM_A_REFR ESH, as shown in the following example:
>
DBMS_SNAPSHOT.S ET_I_AM_A_REFRE SH(value =TRUE);
>
Once again, please remember i'm still very new at Oracle, but would this
script be my answer?
effectively *disable* replication. I found out by just searching on
'I_AM_A_REFRESH ' on tahiti.oracle.c om
Also this function is likely not available in older versions.
Please try getting the full picture of replication. It is much less
simple than you seem to think.
Sybrand Bakker
Senior Oracle DBA