ORA-00922: missing or invalid option

This error is caused by syntax error or missing keyword during sql query execution

SQL> alter system reset "_OPTIMIZER_ADAPTIVE_PLANS";
alter system reset "_OPTIMIZER_ADAPTIVE_PLANS"
*
ERROR at line 1:
ORA-00922: missing or invalid option

Check the correct syntax and reexecute the query

Leave a Reply