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;
We have solved ORA-00922 and successfully grant some quota to the user.