Definition:
In Oracle, the USER_REPCAT_TEMPLATE_OBJECTS view maintains the definitions of the objects which are contained by the deployment templates owned by the current user. The structure of the data dictionary view attributes is shown below.
refresh_template_name [VARCHAR2(30)] -Deployment template name
object_name [VARCHAR2(30)]- Deployment template object name
object_type [VARCHAR2(17)]- The object type of the deployment template object
ddl_num [NUMBER] - Specfies the order of execution of DDL statements contained in DDL_TEXT column
ddl_text [CLOB] - DDL statement to be executed to create deployment object
master_rollback_segment [VARCHAR2(30)] - Rollback segment used during the instantiation of the deployment template object
flavor_id [NUMBER] - Flavor ID
derived_from_sname [VARCHAR2(30)] - Schema from which the deployment object is created
derived_from_oname [VARCHAR2(30)] - Object name from which the deployment object is created
