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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s