Oracle Database Errors or Warnings from Error ORA-02181 to ORA-02190



ORA-02181: invalid option to ROLLBACK WORK
Cause: A token other than TO follows ROLLBACK [WORK].
Action: Place nothing or TO SAVEPOINT <name> after ROLLBACK [WORK].
ORA-02182: savepoint name expected
Cause: An identifier does not follow ROLLBACK [WORK] TO [SAVEPOINT].
Action: Place a savepoint name following TO [SAVEPOINT].
Cause: There is a syntax error in the user’s statement.
Action: Correct the syntax as indicated.

ORA-02184: resource quotas are not allowed in REVOKE
Cause: In a revoke statement, a resource quota was specified.
Action: Specify resource privilege without the quota.
ORA-02185: a token other than WORK follows COMMIT
Cause: A token other than WORK follows COMMIT.
Action: Place either nothing or WORK after COMMIT.
ORA-02186: tablespace resource privilege may not appear with other privileges
Cause: An attempt was made to grant or revoke a resource quota in the same statement in which other privileges are granted or revoked.
Action: Use a separate grant or revoke statement for the resource quota privilege.

ORA-02187: invalid quota specification
Cause: In a grant or revoke statement, the user attempted to grant a tablespace quota above the upper limit.
Action: Grant a smaller tablespace quota.
ORA-02188: Cannot enable instance publicly
Cause: An attempt was made to publicly enable a thread associated with an instance.
Action: Leave out the PUBLIC keyword.
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.
ORA-02190: keyword TABLES expected
Cause: The keyword TABLES is expected following DROP CLUSTER <name> INCLUDING.
Action: Place TABLES after INCLUDING.

Above are list of Oracle Database Errors or Warnings from Error ORA-02181 to ORA-02190 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *