DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_REPCAT_TEMPLATE_OBJECTS

Object Details
Object Name: CDB_REPCAT_TEMPLATE_OBJECTS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
REFRESH_TEMPLATE_NAME VARCHAR2 (30) Yes Name of the refresh group template.
OBJECT_NAME VARCHAR2 (128) Yes Name of the database object.
OBJECT_TYPE VARCHAR2 (200)
Type of database object.
DDL_NUM NUMBER

Order of DDLs for creating the object.
DDL_TEXT CLOB (4000)
DDL string for creating the object or WHERE clause for snapshot query.
MASTER_ROLLBACK_SEGMENT VARCHAR2 (30)
Rollback segment for use during snapshot refreshes.
DERIVED_FROM_SNAME VARCHAR2 (128)
Schema name of schema containing object this was derived from.
DERIVED_FROM_ONAME VARCHAR2 (128)
Object name of object this object was derived from.
FLAVOR_ID NUMBER

Foreign key to the REPCAT$_FLAVORS table.
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REFRESH_TEMPLATE_NAME
,      OBJECT_NAME
,      OBJECT_TYPE
,      DDL_NUM
,      DDL_TEXT
,      MASTER_ROLLBACK_SEGMENT
,      DERIVED_FROM_SNAME
,      DERIVED_FROM_ONAME
,      FLAVOR_ID
,      CON_ID
FROM SYS.CDB_REPCAT_TEMPLATE_OBJECTS;

Dependencies

[top of page]

SYS.CDB_REPCAT_TEMPLATE_OBJECTS does not reference any database object

SYS.CDB_REPCAT_TEMPLATE_OBJECTS is referenced by following:

SchemaPUBLIC
SynonymCDB_REPCAT_TEMPLATE_OBJECTS