select
a.schema_name,
a.table_name,
a.refresh_mode,
a.refresh_ability,
s.job_start_time,
s.job_end_time,
s.row_update_count,
s.status,
s.error_message
from sys.aclmv$_base_view a, sys.aclmvrefstat$ s
where a.acl_mview_obj# = s.acl_mview_obj#
SELECT
A.SCHEMA_NAME
,
A.TABLE_NAME
,
A.REFRESH_MODE
,
A.REFRESH_ABILITY
,
S.JOB_START_TIME
,
S.JOB_END_TIME
,
S.ROW_UPDATE_COUNT
,
S.STATUS
,
S.ERROR_MESSAGE
FROM SYS.ACLMV$_BASE_VIEW A
, SYS.ACLMVREFSTAT$ S
WHERE A.ACL_MVIEW_OBJ# = S.ACL_MVIEW_OBJ#
|
|
|