SYS.ALL_VIEWS

The SYS.ALL_VIEWS view describes all views accessible to the current user. The column names and data types are the same as the Oracle database. TimesTen returns NULL for some columns that are not supported in TimesTen. You should ignore such columns. See the Description column in the Columns table.

Related views

  • SYS.DBA_VIEWS describes all views in the database.

  • SYS.USER_VIEWS describes all views in the database that are owned by the current user.

Columns

Column name Type Description

OWNER

VARCHAR2(30) INLINE

Owner of the view

VIEW_NAME

VARCHAR2(30) INLINE

Name of the view

TEXT_LENGTH

NUMBER

Length of the view text

TEXT

VARCHAR2(409600) NOT INLINE

View text

TYPE_TEXT_LENGTH

NUMBER

Unused

(Column unused by TimesTen. Ignore value.)

TYPE_TEXT

VARCHAR2(4000) NOT INLINE

Unused

(Column unused by TimesTen. Ignore value.)

OID_TEXT_LENGTH

NUMBER

Unused

(Column unused by TimesTen. Ignore value.)

OID_TEXT

VARCHAR2(4000) NOT INLINE

Unused

(Column unused by TimesTen. Ignore value.)

VIEW_TYPE_OWNER

VARCHAR2(30) INLINE

Unused

(Column unused by TimesTen. Ignore value.)

VIEW_TYPE

VARCHAR2(30) INLINE

Unused

(Column unused by TimesTen. Ignore value.)

SUPERVIEW_NAME

VARCHAR2(30) INLINE

Unused

(Column unused by TimesTen. Ignore value.)

EDITIONING_VIEW

VARCHAR2(1) INLINE NOT NULL

Unused

Value returned is N. (Column unused by TimesTen. Ignore value.)

READ_ONLY

VARCHAR2(1) INLINE NOT NULL

Unused

Value returned is Y. (Column unused by TimesTen. Ignore value.)