Oracle Database Errors or Warnings from Error ORA-02161 to ORA-02170

SQLServerF1

 

ORA-02161: invalid value for MAXLOGFILES
Cause: A number does not follow MAXLOGFILES.
Action: Specify a number after MAXLOGFILES.
ORA-02162: invalid value for MAXDATAFILES
Cause: A number does not follow MAXDATAFILES.
Action: Specify a number after MAXDATAFILES.
ORA-02163: invalid value for FREELIST GROUPS
Cause: A number does not follow FREELIST GROUPS.
Action: Specify a number after FREELIST GROUPS.

ORA-02164: DATAFILE clause specified more than once
Cause: The CREATE DATABASE command contains more than one DATAFILE clause.
Action: Specify at most one DATAFILE clause.
ORA-02165: invalid option for CREATE DATABASE
Cause: An invalid CREATE DATABASE option is present.
Action: Specify only valid CREATE DATABASE options.
ORA-02166: ARCHIVELOG and NOARCHIVELOG specified
Cause: Both ARCHIVELOG and NOARCHIVELOG are specified in a CREATE DATABASE statement.
Action: Specify at most one of these two options.

ORA-02167: LOGFILE clause specified more than once
Cause: The CREATE DATABASE command contains more than one LOGFILE clause.
Action: Specify at most one LOGFILE clause.
ORA-02168: invalid value for FREELISTS
Cause: A number does not follow FREELISTS
Action: Specify a number after FREELISTS
ORA-02169: FREELISTS storage option not allowed
Cause: The user attempted to specify the FREELISTS storage option. This option may only be specified during create table or create index.
Action: Remove these options and retry the statement.
ORA-02170: FREELIST GROUPS storage option not allowed
Cause: The user attempted to specify the FREELIST GROUPS storage option. This option may only be specified during create table and when allow_freelist_groups INIT.ORA is specified.
Action: Remove this option and retry the statement or set the allow_freelist_groups INIT.ORA parameter.

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