Database DataWarehousing (MOSC)

MOSC Banner

QSM-00781: the specified value MVIEW_ONLY is invalid for parameter EXECUTION_TYPE. Valid keywords a

edited Jan 14, 2010 12:39AM in Database DataWarehousing (MOSC) 2 commentsAnswered
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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center