3.139 ALL_VIEWS_AE

ALL_VIEWS_AE describes the views (across all editions) accessible to the current user.

Related Views

  • DBA_VIEWS_AE describes all views (across all editions) in the database.

  • USER_VIEWS_AE describes the views (across all editions) owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

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_NULLFoot 1

VARCHAR2(3)

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

PDB_LOCAL_ONLYFoot 1

VARCHAR2(3)

For internal use only

Footnote 1 This column is available starting with Oracle Database release 19c, version 19.1.

See Also: