All Oracle Error CodesOracle DBA Forum

ORA-02189:

ON <tablespace> required
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.