[Home] [Help]
[Dependency Information]
VIEW: SYS.USER_TUNE_MVIEW
Object Details
Object Name: | USER_TUNE_MVIEW |
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
tune_mview catalog view owned by the user
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
TASK_NAME |
VARCHAR2 |
(128) |
|
ID of the action |
ACTION_ID |
NUMBER |
|
Yes |
|
SCRIPT_TYPE |
VARCHAR2 |
(14) |
|
|
STATEMENT |
CLOB |
(4000) |
|
Action statement |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT TASK_NAME
, ACTION_ID
, SCRIPT_TYPE
, STATEMENT
FROM SYS.USER_TUNE_MVIEW;
Dependencies
[top of page]
SYS.USER_TUNE_MVIEW references the following:
-
SYS
-
WRI$_ADV_ACTIONS
-
WRI$_ADV_TASKS
SYS.USER_TUNE_MVIEW is referenced by following:
-
PUBLIC
-
USER_TUNE_MVIEW