ORA-02189: ON <tablespace> required



ORA-02189: ON <tablespace> required..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19580: %s conversation not active

1 Answers  


ORA-24165: invalid rule engine object privilege: string

1 Answers  


ORA-24327: need explicit attach before authenticating a user

1 Answers  


ORA-36608: (XSAGHOVERFLOW) The depth of the hierarchies encountered while processing a composite dimension in AGGREGATE caused a counter overflow.

1 Answers  


ORA-19697: standby controlfile not found in backup set

1 Answers  






ORA-02737: osnpcl: cannot tell orapop to exit

1 Answers  


ORA-02232: invalid MOUNT mode

1 Answers  


ORA-09342: Detached process terminated by Oracle during shutdown abort

2 Answers  


NNO-00701: warning: cannot construct checkpoint file name, checkpointing disabled

1 Answers  


SQL*Loader-00488: %s not a named collection type for filler field string

1 Answers  


NNL-00299: Scheduled server cache dump to occur in string

1 Answers  


PLS-00241: invalid external type specification for SQLSTATE

1 Answers  


Categories