[Home] [Help] [Dependency Information]
Object Name: | DBA_ADVISOR_RATIONALE |
---|---|
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) | ||
EXECUTION_NAME | VARCHAR2 | (128) | ||
REC_ID | NUMBER | |||
RATIONALE_ID | NUMBER | Yes | ||
IMPACT_TYPE | VARCHAR2 | (4000) | ||
IMPACT | NUMBER | |||
MESSAGE | VARCHAR2 | (4000) | ||
OBJECT_ID | NUMBER | |||
TYPE | VARCHAR2 | (30) | ||
ATTR1 | VARCHAR2 | (4000) | ||
ATTR2 | VARCHAR2 | (4000) | ||
ATTR3 | VARCHAR2 | (4000) | ||
ATTR4 | VARCHAR2 | (4000) | ||
ATTR5 | CLOB | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TASK_ID
, TASK_NAME
, EXECUTION_NAME
, REC_ID
, RATIONALE_ID
, IMPACT_TYPE
, IMPACT
, MESSAGE
, OBJECT_ID
, TYPE
, ATTR1
, ATTR2
, ATTR3
, ATTR4
, ATTR5
FROM SYS.DBA_ADVISOR_RATIONALE;
|
|
|