Tuesday, September 16, 2008

DBA_DIMENSIONS

DBA_DIMENSIONS represents dimension objects. Its columns are the same as those in "ALL_DIMENSIONS".

Related Views

· ALL_DIMENSIONS describes dimension objects accessible to the current user.

· USER_DIMENSIONS describes dimensions in the current user's schema.

Column

Datatype

NULL

Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension

INVALID

VARCHAR2(1)

Indicates whether the dimension is invalid (Y) or valid (N)

COMPILE_STATE

VARCHAR2(13)

Compile status of the dimension:

· INVALID

· NEEDS_COMPILE

· ERROR

REVISION

NUMBER

Dimension revision level

Oracle data dictionary views

Oracle dynamic performance views

No comments:

Post a Comment