ALL_REPCAT_TEMPLATE_OBJECTS

Contains the individual object definitions that are contained in each deployment template accessible to the current user. Individual objects are added to a template by specifying the target template in REFRESH_TEMPLATE_NAME.

DDL_TEXT can contain variables to create parameterized templates. Variables are created by placing a colon (:) at the beginning of the variable name (that is, :region). Parameterized templates allow for greater flexibility during the template instantiation process (that is, in defining data sets specific for a snapshot site).

When the object is added to the template, the specified DDL is examined and if any parameters have been defined, Oracle automatically adds the parameter to the ALL_REPCAT_TEMPLATE_PARMS view.

Related views:

• DBA_REPCAT_TEMPLATE_OBJECTS describes the object definitions for all deployment templates in the database.

• USER_REPCAT_TEMPLATE_OBJECTS describes the object definitions for each deployment template owned by the current user.

  Column	Datatype	NULL	Description
  REFRESH_TEMPLATE_NAME	VARCHAR2(30)	NOT NULL	The name of the deployment template.
  OBJECT_NAME	VARCHAR2(30)	NOT NULL	The name of the deployment template object.
  OBJECT_TYPE	VARCHAR2(17)		The object type of the deployment template object.
  DDL_TEXT	CLOB(4000)		The DDL that is executed to create the deployment template object.
  MASTER_ROLLBACK_SEGMENT	VARCHAR2(30)		The name of the rollback segment that is used during the instantiation of the deployment template object.
  DERIVED_FROM_SNAME	VARCHAR2(30)		If applicable, displays the schema that contains the object from which the template object was created.
  DERIVED_FROM_ONAME	VARCHAR2(30)		If applicable, displays the name of the object from which the template object was created.
  FLAVOR_ID	NUMBER		The flavor ID of the deployment template object.

Because the DDL_TEXT parameter is defined as a CLOB, you receive an error if you simply try to perform a SELECT on the ALL_REPCAT_TEMPLATE_OBJECTS view. If you do not need to see the object DDL, use the following select statement (be sure to exclude the DDL_TEXT parameter):

SELECT refresh_template_name, object_name, object_type, master_rollback_seg, 
flavor_id FROM dba_repcat_template_objects;

The following script uses cursors and the DBMS_LOB package to view the entire contents of the ALL_REPCAT_TEMPLATE_OBJECTS view. Use this script to view the entire contents of the ALL_REPCAT_TEMPLATE_OBJECTS view, including the DDL_TEXT column:

SET SERVEROUTPUT ON

DECLARE
  CURSOR mycursor IS
        SELECT refresh_template_name, object_name, object_type, ddl_text,
          master_rollback_seg, flavor_id
          FROM dba_repcat_template_objects;
  tempstring VARCHAR2(1000);
  len NUMBER;
BEGIN
  FOR myrec IN mycursor LOOP
        len := DBMS_LOB.GETLENGTH(myrec.ddl_text);
        DBMS_LOB.READ(myrec.ddl_text, len, 1, tempstring);
        DBMS_OUTPUT.PUT_LINE(myrec.refresh_template_name||' '||
          myrec.object_name||' '||myrec.object_type||' '||tempstring||' '||
          myrec.master_rollback_seg||' '||myrec.flavor_id);
  END LOOP;
END;
/

See Also: Oracle8i Application Developer's Guide - Fundamentals for more information on using cursors. Also, see Oracle8i Application Developer's Guide - Large Objects (LOBs) for more information on using the DBMS_LOB package and LOBs in general.