OWNER

VARCHAR2(128)

NOT NULL

Owner of the view

VIEW_NAME

VARCHAR2(128)

NOT NULL

Name of the view

TEXT_LENGTH

NUMBER

Length of the view text

TEXT

LONG

View text. The BEQUEATH clause will not appear as part of the TEXT column in this view.

TEXT_VC

VARCHAR2(4000)

View text. This column may truncate the view text. The BEQUEATH clause will not appear as part of the TEXT_VC column in this view.

TYPE_TEXT_LENGTH

NUMBER

Length of the type clause of the typed view

TYPE_TEXT

VARCHAR2(4000)

Type clause of the typed view

OID_TEXT_LENGTH

NUMBER

Length of the WITH OID clause of the typed view

OID_TEXT

VARCHAR2(4000)

WITH OID clause of the typed view

VIEW_TYPE_OWNER

VARCHAR2(128)

Owner of the type of the view if the view is an typed view

VIEW_TYPE

VARCHAR2(128)

Type of the view if the view is a typed view

SUPERVIEW_NAME

VARCHAR2(128)

Name of the superview, if the view is a subview

EDITIONING_VIEW

VARCHAR2(1)

Indicates whether the view is an editioning view (Y) or not (N)

READ_ONLY

VARCHAR2(1)

Indicates whether the view is read-only (Y) or not (N)

EDITION_NAME

VARCHAR2(128)

Name of the application edition where the object is defined

CONTAINER_DATA

VARCHAR2(1)

Indicates whether the view contains container-specific data. Possible values:

• Y if the view was created with the CONTAINER_DATA clause

• N otherwise

BEQUEATH

VARCHAR2(12)

Possible values:

• CURRENT_USER: When the view is a BEQUEATH CURRENT_USER view

• DEFINER: When the view is a BEQUEATH DEFINER view

For more information about the syntax and semantics of the BEQUEATH clause in the SQL CREATE VIEW statement, see Oracle Database SQL Language Reference.

ORIGIN_CON_ID

NUMBER

The ID of the container where the data originates. Possible values include:

• 0: This value is used for rows in non-CDBs. This value is not used for CDBs.

• n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root)

DEFAULT_COLLATION

VARCHAR2(100)

Default collation for the view

CONTAINERS_DEFAULT

VARCHAR2(3)

Indicates whether the view is enabled for CONTAINERS() by default (YES) or not (NO)

CONTAINER_MAP

VARCHAR2(3)

Indicates whether the view is enabled for use with the container_map database property (YES) or not (NO)

EXTENDED_DATA_LINK

VARCHAR2(3)

Indicates whether the view is enabled for fetching an extended data link from the root (YES) or not (NO)

EXTENDED_DATA_LINK_MAP

VARCHAR2(3)

For internal use only

HAS_SENSITIVE_COLUMN

VARCHAR2(3)

Indicates whether the view has one or more sensitive columns (YES) or not (NO)

ADMIT_NULL^Foot 1

VARCHAR2(3)

Indicates whether the view admits null CON_ID data (YES) or not (NO)

PDB_LOCAL_ONLY^Footref 1

VARCHAR2(3)

For internal use only