Name | Value |
---|---|
CREATED | 27/08/11 |
LAST_DDL_TIME | 27/08/11 |
OWNER | SYSTEM |
VIEW_NAME | MVIEW_LOG |
TEXT_LENGTH | 596 |
TEXT | select m.runid# as id, m.filterid# as filterid, m.run_begin, m.run_end, decode(m.run_type,1,'EVALUATE',2,'EVALUATE_W',3,'RECOMMEND', 4,'RECOMMEND_W',5,'VALIDATE',6,'WORKLOAD', 7,'FILTER','UNKNOWN') AS type, decode(m.status,0,'UNUSED',1,'CANCELLED',2,'IN_PROGRESS',3,'COMPLETED', 4,'ERROR','UNKNOWN') AS status, m.message, m.completed, m.total, m.error_code from system.mview$_adv_log m, all_users u where m.uname = u.username and u.user_id = userenv('SCHEMAID') |
TYPE_TEXT_LENGTH | null |
TYPE_TEXT | null |
OID_TEXT_LENGTH | null |
OID_TEXT | null |
VIEW_TYPE_OWNER | null |
VIEW_TYPE | null |
SUPERVIEW_NAME | null |
EDITIONING_VIEW | N |
READ_ONLY | N |