ALL_REPCAT _TEMPLATE_OBJECTS

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

DDL_TEXT can contain variables to create p arameterized templates. Variables are created by placing a colon (:) at the beginning of the variable name (for example, :region). Te mplates that use parameters allow for greater flexibility during the template instantiation process (that is, in defining data sets s pecific for a materialized view site).

When the object is added to the template, the specifie d DDL is examined and if any parameters have been defined, Oracle automatically adds the parameter to the ALL_REPCAT_TEMPLATE_P ARMS view.

Related Views:

• DBA_REPCAT_TEMP LATE_OBJECTS describes the object definitions for all deployment templates in the database.
• < a name="35675">USER_REPCAT_TEMPLATE_OBJECTS describes the object definitions for each deployment template owned by t he current user.

  -

  Column	Datatype	NULL	Description
  REFRESH_TEMPLATE_NAME	VARCHAR2(30)	NO T NULL	The name of the deployment template.
  OBJECT_NAME	VARCHAR2(30)	NOT NULL	The name of the deploymen t template object.
  OBJECT_TYPE	VARCHAR2(17)	The object type of the deployment template object: FUNCTION MATERIALIZED VIEW INDEX SYNONYM INDEXTYPE TABLE OPERATOR TRIGGER PACKAGE TYPE PACKAGE BODY TYPE BODY PROCEDURE VIEW
  DDL_NUM	NUMBER	NOT NULL	Indicates the orde r in which to execute the DDL statements stored in the DDL_TEXT column when multiple DDL statements are used to create t he object.
  DDL_TEXT	CLOB(4000)	-	The DDL that is execute d 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.< /p>
  DERIVED_ FROM_SNAME	VARCHAR2(30)	-	If applicable, display s 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 ob ject was created.
  FLAVOR_ID	NUMBER	-	The flavor ID of th e deployment template object.

Because the DDL_TEXT< /code> 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, O
BJECT_TYPE, MASTER_ROLLBACK_SEG, 
FLAVOR_ID FROM DBA_REPCAT_TEMPLATE_OBJECTS;

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;
/