[Home] [Help] [Dependency Information]
Object Name: | DBA_ADVISOR_DIRECTIVES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | ||
TASK_ID | NUMBER | Yes | ||
TASK_NAME | VARCHAR2 | (128) | ||
SOURCE_TASK_ID | NUMBER | |||
DIRECTIVE_ID | NUMBER | Yes | ||
REC_OBJ_OWNER | VARCHAR2 | (30) | ||
REC_OBJ_NAME | VARCHAR2 | (30) | ||
REC_ID | NUMBER | |||
REC_ACTION_ID | NUMBER | |||
COMMAND | VARCHAR2 | (64) | ||
ATTR1 | VARCHAR2 | (2000) | ||
ATTR2 | VARCHAR2 | (2000) | ||
ATTR3 | VARCHAR2 | (2000) | ||
ATTR4 | VARCHAR2 | (2000) | ||
ATTR5 | CLOB | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TASK_ID
, TASK_NAME
, SOURCE_TASK_ID
, DIRECTIVE_ID
, REC_OBJ_OWNER
, REC_OBJ_NAME
, REC_ID
, REC_ACTION_ID
, COMMAND
, ATTR1
, ATTR2
, ATTR3
, ATTR4
, ATTR5
FROM SYS.DBA_ADVISOR_DIRECTIVES;
|
|
|