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


VIEW: SYS._ALL_REPGROUPED_COLUMN

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

Columns in the all column groups of 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
GROUP_NAME VARCHAR2 (30)
Name of the column group
COLUMN_NAME VARCHAR2 (128)
Name of the column in the column group
POS NUMBER

Position of the column in the table
Query Text

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


SELECT SNAME
,      ONAME
,      GROUP_NAME
,      COLUMN_NAME
,      POS
FROM SYS._ALL_REPGROUPED_COLUMN;

Dependencies

[top of page]

SYS._ALL_REPGROUPED_COLUMN references the following:

SchemaSYS
ViewALL_TAB_COLUMNS
PL/SQL PackageUTL_RAW - show dependent code
PL/SQL PackageXML_SCHEMA_NAME_PRESENT - show dependent code
View_ALL_REPL_NESTED_TABLE_NAMES
SchemaSYSTEM
TableREPCAT$_GROUPED_COLUMN
TableREPCAT$_REPCOLUMN
SYS._ALL_REPGROUPED_COLUMN is referenced by following:

SchemaSYS
Package BodyDBMS_REPCAT_RGT_CUST - show dependent code
View_ALL_REPCOLUMN_GROUP