eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS._ALL_REPCOLUMN

Object Details

Object Name:	_ALL_REPCOLUMN
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Replicated top-level columns (table) sorted alphabetically in ascending order

[View Source]

Columns

Name	Datatype	Length	Comments
SNAME	VARCHAR2	(128)	Name of the object owner
ONAME	VARCHAR2	(128)	Name of the object
TYPE	NUMBER		Type of the object
LONG_CNAME	VARCHAR2	(4000)	Long column name of the replicated column
ID	NUMBER		ID of the replicated column
POS	NUMBER		Ordering of the replicated column
FLAG	RAW	(2)	Replication information about column
CTYPE	NUMBER		Type name of the column
DATA_LENGTH	NUMBER		Length of the column in bytes
DATA_PRECISION	NUMBER		Length: decimal digits (NUMBER) or binary digits (FLOAT)
DATA_SCALE	NUMBER		Digits to right of decimal point in a number
NULL$	NUMBER		Does column allow NULL values?
CHARSETID	NUMBER		Character set identifier
CHARSETFORM	NUMBER		Character set form
CNAME	VARCHAR2	(128)	Internal column name of the replicated column
CTYPE_TOID	RAW	(16)	Type OID of a column of TYPE
CTYPE_OWNER	VARCHAR2	(128)	Type owner of a column of TYPE
CTYPE_NAME	VARCHAR2	(128)	Type name of a column of TYPE
CTYPE_VERSION#	NUMBER		Type version# of a column of TYPE
CTYPE_HASHCODE	RAW	(17)	Type hashcode of a column of TYPE
TOP	VARCHAR2	(128)	Top column of this attribute column
PROPERTY	RAW	(4)	Property of this column
CHAR_LENGTH	NUMBER		The maximum length of the column in characters

Query Text

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


SELECT SNAME
,      ONAME
,      TYPE
,      LONG_CNAME
,      ID
,      POS
,      FLAG
,      CTYPE
,      DATA_LENGTH
,      DATA_PRECISION
,      DATA_SCALE
,      NULL$
,      CHARSETID
,      CHARSETFORM
,      CNAME
,      CTYPE_TOID
,      CTYPE_OWNER
,      CTYPE_NAME
,      CTYPE_VERSION#
,      CTYPE_HASHCODE
,      TOP
,      PROPERTY
,      CHAR_LENGTH
FROM SYS._ALL_REPCOLUMN;

Dependencies

[top of page]

SYS._ALL_REPCOLUMN references the following:

SYS: ALL_TAB_COLUMNS; UTL_RAW - show dependent code; XML_SCHEMA_NAME_PRESENT - show dependent code; _ALL_REPL_NESTED_TABLE_NAMES
SYSTEM: REPCAT$_REPCOLUMN

SYS._ALL_REPCOLUMN is not referenced by any database object