Instantiate Deployment Template

After the instantiation script has been distributed to the remote snapshot sites, you are ready to instantiate the deployment template at the remote snapshot site.

See Also: Chapter 7, "Planning Your Replication Environment" in Oracle8i Replication for snapshot site requirements that must be met before instantiating your deployment template.

The following script demonstrates how to complete the instantiation process at a remote snapshot site with Oracle8i Enterprise Edition, Oracle8i Standard Edition, or Oracle8i Personal Edition installed. These instructions do not apply to snapshot sites with Oracle8i Lite installed. Instead, Oracle8i Lite snapshot sites use a client application, such as the Oracle Client Replication Tool, to instantiate deployment templates.

See Also: See the Oracle8i Lite documentation for information about instantiating deployment templates at Oracle8i Lite snapshot sites.

/*************************************************************************
STEP 1:
CREATE SCHEMA AND DATABASE LINKS
*************************************************************************/

--Before you execute the instantiation script at the remote snapshot site,
--you must create the schema that contains the replicated objects. Use 
--SQL*Plus to complete Step 1 and Step 2.

CONNECT system/manager@snap1.world

CREATE USER scott IDENTIFIED BY tiger;

GRANT CONNECT, RESOURCE TO scott;

--Before you can create the private database link, you must create a public
--database link.

CREATE PUBLIC DATABASE LINK orc3.world USING 'orc3.world';

--Connect as the target user (scott) and create a private database link
--to the target master site (the target user must also exist at the master
--site).

CONNECT scott/tiger@snap1.world

CREATE DATABASE LINK orc3.world 
   CONNECT TO scott IDENTIFIED BY tiger;

/*************************************************************************
STEP 2:
EXECUTE THE INSTANTIATION SCRIPT
*************************************************************************/

@d:\snap1_world.sql

Depending on the size of the snapshot environment created and the amount of data loaded, the instantiation procedure may take a substantial amount of time.

Refresh After Instantiation

If you have just instantiated a deployment template using the offline instantiation method, you should perform a refresh as soon as possible. Issue the following execute statement:

execute DBMS_REFRESH.REFRESH('PERSONNEL');