Showing posts with label ORA-02189. Show all posts
Showing posts with label ORA-02189. Show all posts

Monday, 23 January 2012

ORA-02189: ON lamp;lt;lamp;nbsp;tablespacelamp;gt; required

ORA-02189: ON lamp;lt;lamp;nbsp;tablespacelamp;gt; required

Cause: In a grant or revoke statement, the user specified a tablespace quota but did not follow it with the ON lamp;lt;lamp;nbsp;tablespacelamp;gt; clause.

Action: Specify the tablespace on which the quota is to be applied with the ON lamp;lt;lamp;nbsp;tablespacelamp;gt; clause.