Skip to content

How to Resolve ORA-00922: missing or invalid option

  • by

ORA-00922

Tried to grant some quota on tablespace to an user, but it failed with ORA-00922.

SQL> alter user hr quota 100g on tablespace users;
alter user hr quota 100g on tablespace users
                                       *
ERROR at line 1:
ORA-00922: missing or invalid option

ORA-00922 means that SQL parser found an invalid option where should be empty or one of other valid options it expects.

In this case, the keyword TABLESPACE shall not be used in this clause, just use a normal tablespace name after ON.

SQL> alter user hr quota 100g on users;

User altered.

We have solved ORA-00922 and successfully grant some quota to the user.

Leave a Reply

Your email address will not be published. Required fields are marked *