Oracle® Database Advanced Replication Management API Reference 10g Release 1 (10.1) Part Number B10733-01 |
|
|
View PDF |
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.
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.
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:
Oracle Database Application Developer's Guide - Fundamentals for more information on using cursors. Also, see Oracle Database Application Developer's Guide - Large Objects for more information on using the |