QSM-00781: the specified value MVIEW_ONLY is invalid for parameter EXECUTION_TYPE. Valid keywords a
Hi,
I just hit this issue with DBMS_ADVISOR.TUNE_MVIEW. Metalink only finds one reference and the case was dropped.
ORA-13600: error encountered in Advisor
QSM-00781: the specified value MVIEW_ONLY is invalid for parameter EXECUTION_TYPE. Valid keywords are FULL, INDEX_ONLY
ORA-06512: at "SYS.PRVT_ADVISOR", line 2931
ORA-06512: at "SYS.DBMS_ADVISOR", line 287
ORA-06512: at "SYS.PRVT_TUNE_MVIEW", line 604
ORA-06512: at "SYS.PRVT_TUNE_MVIEW", line 1061
ORA-06512: at "SYS.DBMS_ADVISOR", line 754
ORA-06512: at line 6
Any ideas?
I just hit this issue with DBMS_ADVISOR.TUNE_MVIEW. Metalink only finds one reference and the case was dropped.
ORA-13600: error encountered in Advisor
QSM-00781: the specified value MVIEW_ONLY is invalid for parameter EXECUTION_TYPE. Valid keywords are FULL, INDEX_ONLY
ORA-06512: at "SYS.PRVT_ADVISOR", line 2931
ORA-06512: at "SYS.DBMS_ADVISOR", line 287
ORA-06512: at "SYS.PRVT_TUNE_MVIEW", line 604
ORA-06512: at "SYS.PRVT_TUNE_MVIEW", line 1061
ORA-06512: at "SYS.DBMS_ADVISOR", line 754
ORA-06512: at line 6
Any ideas?
0