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

VIEW: SYS.DBA_VIEWS

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

Description of all views in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the view
VIEW_NAME VARCHAR2 (128) Yes Name of the view
TEXT_LENGTH NUMBER

Length of the view text
TEXT LONG (0)
View text
TEXT_VC VARCHAR2 (4000)
Possibly truncated view text as VARCHAR2
TYPE_TEXT_LENGTH NUMBER

Length of the type clause of the object view
TYPE_TEXT VARCHAR2 (4000)
Type clause of the object view
OID_TEXT_LENGTH NUMBER

Length of the WITH OBJECT OID clause of the object view
OID_TEXT VARCHAR2 (4000)
WITH OBJECT OID clause of the object view
VIEW_TYPE_OWNER VARCHAR2 (128)
Owner of the type of the view if the view is an object view
VIEW_TYPE VARCHAR2 (128)
Type of the view if the view is an object view
SUPERVIEW_NAME VARCHAR2 (128)
Name of the superview, if view is a subview
EDITIONING_VIEW VARCHAR2 (1)
An indicator of whether the view is an Editioning View
READ_ONLY VARCHAR2 (1)
An indicator of whether the view is a Read Only View
CONTAINER_DATA VARCHAR2 (1)
An indicator of whether the view contains Container-specific data
BEQUEATH VARCHAR2 (12)
An indicator of whether the view is invoker rights
ORIGIN_CON_ID NUMBER

ID of Container where row originates
Query Text

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


SELECT OWNER
,      VIEW_NAME
,      TEXT_LENGTH
,      TEXT
,      TEXT_VC
,      TYPE_TEXT_LENGTH
,      TYPE_TEXT
,      OID_TEXT_LENGTH
,      OID_TEXT
,      VIEW_TYPE_OWNER
,      VIEW_TYPE
,      SUPERVIEW_NAME
,      EDITIONING_VIEW
,      READ_ONLY
,      CONTAINER_DATA
,      BEQUEATH
,      ORIGIN_CON_ID
FROM SYS.DBA_VIEWS;

Dependencies

[top of page]

SYS.DBA_VIEWS references the following:

SchemaSYS
FunctionGETLONG
ViewINT$DBA_VIEWS
SYS.DBA_VIEWS is referenced by following:

SchemaPUBLIC
SynonymDBA_VIEWS
SchemaSYS
Package BodyDBMSOBJG - show dependent code
Package BodyDBMS_INTERNAL_LOGSTDBY - show dependent code
Package BodyDBMS_PRVTAQIS - show dependent code
Package BodyDBMS_REPCAT_OBJ_UTL - show dependent code
Package BodyDBMS_REPCAT_UTL2 - show dependent code
Package BodyDBMS_REPCAT_UTL4 - show dependent code
Package BodyDBMS_SODA_UTIL - show dependent code
Package BodyXS_DIAG_INT - show dependent code