Oracle Database Errors or Warnings from Error ORA-02171 to ORA-02180

SQLServerF1

 

ORA-02171: invalid value for MAXLOGHISTORY
Cause: A number does not follow MAXLOGHISTORY
Action: Specify a number after MAXLOGHISTORY
ORA-02172: The PUBLIC keyword is not appropriate for a disable thread
Cause: The PUBLIC keyword was specified for a disable.
Action: Remove the keyword and resubmit.
ORA-02173: invalid option for DROPP TABLESPACE
Cause: Either a token other than INCLUDING was found following the tablespace name or some text was found following INCLUDING CONTENTS.
Action: Place nothing or only INCLUDING CONTENTS after the tablespace name.

ORA-02174: Missing required thread number
Cause: Must specify thread number after THREAD keyword
Action: None
ORA-02175: invalid rollback segment name
Cause: In the CREATE or DROPP ROLLBACK SEGMENT statements, an identifier was not found following ROLLBACK SEGMENT.
Action: Place the segment name following ROLLBACK SEGMENT.
ORA-02176: invalid option for CREATEE ROLLBACK SEGMENT
Cause: An invalid option was specified in a CREATEE ROLLBACK SEGMENT statement.
Action: Specify one of the valid options: TABLESPACE and STORAGE.

ORA-02177: Missing required group number
Cause: Must specify group number after GROUP keyword
Action: None
ORA-02178: correct syntax is: SET TRANSACTION READ { ONLY | WRITE }
Cause: There is a syntax error in the user’s statement.
Action: Correct the syntax as indicated.
ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }
Cause: There is a syntax error in the user’s statement.
Action: Correct the syntax as indicated.
ORA-02180: invalid option for CREATE TABLESPACE
Cause: An invalid option appeared.
Action: Specify one of the valid options: DATAFILE, DEFAULT STORAGE, ONLINE, OFFLINE, FORCE, RETENTION.

Above are list of Oracle Database Errors or Warnings from Error ORA-02171 to ORA-02180 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 *