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


VIEW: SYS.ALL_REPPARAMETER_COLUMN

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

All columns used for resolving conflicts in replicated tables which are accessible to the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
SNAME VARCHAR2 (128)
Owner of replicated object
ONAME VARCHAR2 (128)
Name of the replicated object
CONFLICT_TYPE VARCHAR2 (10)
Type of conflict
REFERENCE_NAME VARCHAR2 (128)
Table name, unique constraint name, or column group name
SEQUENCE_NO NUMBER

Ordering on resolution
METHOD_NAME VARCHAR2 (80)
FUNCTION_NAME VARCHAR2 (386)
PRIORITY_GROUP VARCHAR2 (30)
PARAMETER_TABLE_NAME VARCHAR2 (128)
Name of the table to which the parameter column belongs
PARAMETER_COLUMN_NAME VARCHAR2 (4000)
Name of the parameter column used for resolving the conflict
PARAMETER_SEQUENCE_NO NUMBER

Ordering on parameter column
Query Text

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


SELECT SNAME
,      ONAME
,      CONFLICT_TYPE
,      REFERENCE_NAME
,      SEQUENCE_NO
,      METHOD_NAME
,      FUNCTION_NAME
,      PRIORITY_GROUP
,      PARAMETER_TABLE_NAME
,      PARAMETER_COLUMN_NAME
,      PARAMETER_SEQUENCE_NO
FROM SYS.ALL_REPPARAMETER_COLUMN;

Dependencies

[top of page]

SYS.ALL_REPPARAMETER_COLUMN references the following:

SchemaSYS
ViewALL_TAB_COLUMNS
ViewDBA_REPPARAMETER_COLUMN
PL/SQL PackageXML_SCHEMA_NAME_PRESENT - show dependent code
View_ALL_REPL_NESTED_TABLE_NAMES
SchemaSYSTEM
TableREPCAT$_PARAMETER_COLUMN
TableREPCAT$_REPCOLUMN
TableREPCAT$_RESOLUTION
SYS.ALL_REPPARAMETER_COLUMN is referenced by following:

SchemaPUBLIC
SynonymALL_REPPARAMETER_COLUMN