如何手动刷新Oracle中的快照snapshot??

[Michaelyfj]

如何手动刷新oracle中的快照？？？

[rabbit]

使用
DBMS_REPCAT.REFRESH_SNAPSHOT_REPGROUP (
gname IN VARCHAR2,
drop_missing_contents IN BOOLEAN := FALSE,
refresh_snapshots IN BOOLEAN := FALSE,
refresh_other_objects IN BOOLEAN := FALSE);

Parameters
Table 8-175 REFRESH_SNAPSHOT_REPGROUP Procedure Parameters
Parameter Description
gname

Name of the replicated master group.

drop_missing_
contents

If an object was dropped from the replicated master group, then it is not automatically dropped from the schema at the snapshot site. It is simply no longer replicated; that is, changes to this object are no longer sent to its associated master site. Snapshots can continue to be refreshed from their associated master tables; however, any changes to an updatable snapshot are lost. When an object is dropped from the object group, you can choose to have it dropped from the schema entirely by setting this argument to TRUE.

refresh_snapshots

Set this to TRUE to refresh the contents of the snapshots in the replicated master group.

refresh_other_
objects

Set this to TRUE to refresh the contents of the non-snapshot objects in the replicated master group

[Michaelyfj]

在oracle7.3 Group Server之间好象不行啊!
我用 SYS.DBMS_SNAPSHOT.REFRESH 时出错
出错信息如下：
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_SNAPSHOT" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2

[Michaelyfj]

why???