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 (for example, :region). Templates that use parameters allow for greater flexibility during the template instantiation process (that is, in defining data sets specific for a materialized view 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: FUNCTION INDEX INDEXTYPE OPERATOR PACKAGE PACKAGE BODY PROCEDURE SNAPSHOT SYNONYM TABLE TRIGGER TYPE TYPE BODY VIEW
  DDL_NUM	NUMBER	NOT NULL	Indicates the order in which to execute the DDL statements stored in the DDL_TEXT column when multiple DDL statements are used to create the 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 column 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, then 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: Oracle9i Application Developer's Guide - Fundamentals for more information on using cursors. Also, see Oracle9i Application Developer's Guide - Large Objects (LOBs) for more information on using the DBMS_LOB package and LOBs in general.