Oracle Deployment Templates Concepts

Oracle offers deployment templates to allow the database administrator to package a snapshot environment for easy, custom, and secure distribution and installation. A deployment template can be simple (for example, it can contain a single snapshot with a fixed data set), or complex (for example, it can contain hundreds of snapshots with a dynamic data set based on one or more variables). The goal is to define the environment once and deploy the deployment template as often as necessary. Oracle deployment templates feature:

• Central control

• Repeated deployment of a snapshot environment

• Data subsetting at remote sites using template parameters

• Authorized user list to control template instantiation and data access

To prepare a snapshot environment for deployment, the DBA creates a deployment template at the master site. This template stores all of the information needed to deploy a snapshot environment, including the DDL to create the objects at the remote site and the target refresh group. This template also maintains links to user security information and template parameters for custom snapshot creation.