Oracle Database Errors or Warnings from Error ORA-02191 to ORA-02200

SQLServerF1

 

ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT <rbs>
Cause: There is a syntax error in the user’s statement.
Action: Correct the syntax as indicated.
ORA-02192: PCTINCREASE not allowed for rollback segment storage clauses
Cause: pctincrease was specified in a create or alter rollback segment
Action: reissue statement without the pctincrease clause
ORA-02194: event specification syntax error string (minor error string) near ‘string’
Cause: There is a syntax error in an event specification.
Action: Fix the error.

ORA-02195: Attempt to create string object in a string tablespace
Cause: The object type is inconsistent with a tablespace contents.
Action: Create an object in a different tablespace, or change the user defaults.
ORA-02196: PERMANENT/TEMPORARY option already specified
Cause: In CREATE TABLESPACE, the PERMANENT and/or TEMPORARY options were specified more than once.
Action: None
ORA-02197: file list already specified
Cause: In CREATE TABLESPACE, more than one DATAFILE/TEMPFILE clause was specified.
Action: Merge the DATAFILE/TEMPFILE clauses into a single clause.

ORA-02198: ONLINE/OFFLINE option already specified
Cause: In CREATE TABLESPACE, the ONLINE and/or OFFLINE options were specified more than once.
Action: Specify at most one of ONLINE or OFFLINE.
ORA-02199: missing DATAFILE/TEMPFILE clause
Cause: A CREATE TABLESPACE statement has no DATAFILE/TEMPFILE clause.
Action: Specify a DATAFILE/TEMPFILE clause.
ORA-02200: WITH GRANT OPTION not allowed for PUBLIC
Cause: An attempt was made to GRANT to PUBLIC WITH GRANT OPTION.
Action: Remove the WITH GRANT OPTION clause.

Above are list of Oracle Database Errors or Warnings from Error ORA-02191 to ORA-02200 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.

Thanks,
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 *