使用
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
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
我用 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