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

VIEW: SYS.ALL_REPOBJECT

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

Information about replicated objects

[View Source]

Columns
Name Datatype Length Mandatory Comments
SNAME VARCHAR2 (128)
Name of the object owner
ONAME VARCHAR2 (128)
Name of the object
TYPE VARCHAR2 (16)
Type of the object
STATUS VARCHAR2 (10)
Status of the last create or alter request on the local object
GENERATION_STATUS VARCHAR2 (9)
Status of whether the object needs to generate replication packages
ID NUMBER

Identifier of the local object
OBJECT_COMMENT VARCHAR2 (80)
Description of the replicated object
GNAME VARCHAR2 (30)
Name of the replicated object group
MIN_COMMUNICATION VARCHAR2 (1)
Send only necessary OLD and NEW values for an updated row?
REPLICATION_TRIGGER_EXISTS VARCHAR2 (1)
Internal replication trigger exists?
INTERNAL_PACKAGE_EXISTS VARCHAR2 (1)
Internal package exists?
GROUP_OWNER VARCHAR2 (128)
Owner of the replicated object group
NESTED_TABLE VARCHAR2 (1)
Storage table for a nested table column?
Query Text

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


SELECT SNAME
,      ONAME
,      TYPE
,      STATUS
,      GENERATION_STATUS
,      ID
,      OBJECT_COMMENT
,      GNAME
,      MIN_COMMUNICATION
,      REPLICATION_TRIGGER_EXISTS
,      INTERNAL_PACKAGE_EXISTS
,      GROUP_OWNER
,      NESTED_TABLE
FROM SYS.ALL_REPOBJECT;

Dependencies

[top of page]

SYS.ALL_REPOBJECT references the following:

SchemaSYS
ViewALL_OBJECTS
ViewALL_USERS
ViewREPCAT_REPOBJECT
ViewUSER_REPGROUP_PRIVILEGES
ViewUSER_REPOBJECT
PL/SQL PackageUTL_RAW - show dependent code
PL/SQL PackageXML_SCHEMA_NAME_PRESENT - show dependent code
SYS.ALL_REPOBJECT is referenced by following:

SchemaPUBLIC
SynonymALL_REPOBJECT
SchemaSYS
ViewALL_REPCOLUMN_GROUP
ViewALL_REPKEY_COLUMNS
ViewALL_REPPROP
Package BodyDBMS_REPCAT_CONF - show dependent code
Package BodyDBMS_REPCAT_UTL - show dependent code