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


VIEW: SYS.ALL_REPPROP

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

Propagation information about replicated objects

[View Source]

Columns
Name Datatype Length Mandatory Comments
SNAME VARCHAR2 (128) Yes Name of the object owner
ONAME VARCHAR2 (128) Yes Name of the object
TYPE VARCHAR2 (16)
Type of the object
DBLINK VARCHAR2 (128) Yes Destination database for propagation
HOW VARCHAR2 (13)
Propagation choice for the destination database
PROPAGATE_COMMENT VARCHAR2 (80)
Description of the propagation choice
Query Text

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


SELECT SNAME
,      ONAME
,      TYPE
,      DBLINK
,      HOW
,      PROPAGATE_COMMENT
FROM SYS.ALL_REPPROP;

Dependencies

[top of page]

SYS.ALL_REPPROP references the following:

SchemaSYS
ViewALL_REPOBJECT
ViewALL_USERS
ViewREPCAT_REPPROP
PL/SQL PackageUTL_RAW - show dependent code
PL/SQL PackageXML_SCHEMA_NAME_PRESENT - show dependent code
SYS.ALL_REPPROP is referenced by following:

SchemaPUBLIC
SynonymALL_REPPROP