Cause
In a grant or revoke statement, the user specified a tablespace quota but did not follow it with the ON tablespace clause.
Action
Specify the tablespace on which the quota is to be applied with the ON tablespace clause.
Oracle 26ai
ORA-02189
Error Message
ONtablespacerequired