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-30079: cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns

1 Answers  


ORA-07235: slemcw: fwrite error.

1 Answers  


ORA-14622: Value string already exists in subpartition string

1 Answers  


ORA-39029: worker string with process name "string" prematurely terminated

1 Answers  


DRG-11732: phrase does not have any translations

1 Answers  






RMAN-06703: could not open file: "string" (reason=string)

1 Answers  


ORA-06107: NETTCP: ORACLE network server not found

1 Answers  


TNS-01190: The user is not authorized to execute the requested listener command

1 Answers  


O2U-00206: Some characters in a type name were not legal identifier characters

1 Answers  


TNS-01090: No longer listening on: string

1 Answers  


ORA-19331: Last argument to CREATE_DBURI operator must be a column

1 Answers  


DRG-11304: function-based indexes are not supported by this indextype

1 Answers  


Categories