Release 8.1.5
A68001-01
 Library |
 Product |
 Contents |
 Index |
| Oracle8i Supplied Packages Reference Release 8.1.5 A68001-01 |
|
The DBMS_REPCAT_INSTANTIATE package instantiates deployment templates.
| Subprogram | Description |
|---|---|
DROP_SITE_INSTANTIATION procedure |
Public procedure that removes the target site from the |
INSTANTIATE_OFFLINE procedure |
Public procedure that generates a script at the master site that is used to create the snapshot environment at the remote snapshot site while offline. |
INSTANTIATE_ONLINE procedure |
Public procedure that generates a script at the master site that is used to create the snapshot environment at the remote snapshot site while online. |
This procedure drops a template instantiation at a target site. This removes all related meta data at the master site and disables the specified site from refreshing their snapshots. You must execute this procedure as the user that originally instantiated the template.
DBMS_REPCAT_INSTANTIATE.DROP_SITE_INSTANTIATION ( refresh_template_name IN VARCHAR2, site_name IN VARCHAR2, repapi_site_id IN NUMBER := -1e-130);
This function generates a script at the master site that is used to create the snapshot environment at the remote snapshot site while offline. This generated script should be used at remote snapshot sites that are not able to remain connected to the master site for an extended amount of time. This is an ideal solution where the remote snapshot site is a laptop. Use the packaging tool in Replication Manager to package the generated script and data into a single file, that can be posted on an FTP site or loaded to a CD-ROM, floppy disk, etc. See "Deploying Template" in the Oracle8i Replication manual for more information.
The script generated by this function is stored in the USER_REPCAT_TEMP_OUTPUT temporary view and is used by several Oracle tools, including Replication Manager, during the distribution of deployment templates. The number returned by this function is used to retrieve the appropriate information from the USER_REPCAT_TEMP_OUTPUT view.
The user that executes this public procedure will become the "registered" user of the instantiated template at the specified site.
|
Note: This procedure is used in performing an offline instantiation of a deployment template. This procedure should not be confused with the procedures in the DBMS_OFFLINE_OG package (used for performing an offline instantiation of a master table) or with the procedures in the DBMS_OFFLINE_SNAPSHOT package (used for performing an offline instantiation of a snapshot). See these respective packages for more information on their usage. |
DBMS_REPCAT_INSTANTIATE.INSTANTIATE_OFFLINE( refresh_template_name IN VARCHAR2, site_name IN VARCHAR2, runtime_parm_id IN NUMBER := -1e-130, next_date IN DATE := SYSDATE, interval IN VARCHAR2 :'SYSDATe + 1') RETURN NUMBER;
This function generates a script at the master site that is used to create the snapshot environment at the remote snapshot site while online. This generated script should be used at remote snapshot sites that are able to remain connected to the master site for an extended amount of time, as the instantiation process at the remote snapshot site may be lengthy (depending on the amount of data that is populated to the new snapshots).
The script generated by this function is stored in the USER_REPCAT_TEMP_OUTPUT temporary view and is used by several Oracle tools, including Replication Manager, during the distribution of deployment templates. The number returned by this function is used to retrieve the appropriate information from the USER_REPCAT_TEMP_OUTPUT view.
The user that executes this public procedure will become the "registered" user of the instantiated template at the specified site.
DBMS_REPCAT_INSTANTIATE.INSTANTIATE_ONLINE( refresh_template_name IN VARCHAR2, site_name IN VARCHAR2, runtime_parm_id IN NUMBER := -1e-130, next_date IN DATE := SYSDATE, interval IN VARCHAR2 :'SYSDATe + 1') RETURN NUMBER;
