Category: Databases

Oracle 11g Error Codes and Solution Suggestions from ORA-02200 to ORA-02300 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. ORA-02201: sequence not allowed here Cause: An attempt was made to reference a sequence in a from-list. Action: A sequence can…

Oracle 11g Error Codes and Solution Suggestions from ORA-02100 to ORA-02200 ORA-02140: invalid tablespace name Cause: An identifier does not follow ALTER TABLESPACE. Action: Specify a tablespace name following ALTER TABLESPACE. ORA-02141: invalid OFFLINE option Cause: An option other than NORMAL or IMMEDIATE follows OFFLINE. Action: The user must either specify no option following OFFLINE or one of the…

Oracle 11g Error Codes and Solution Suggestions from ORA-02000 to ORA-02100 ORA-02001: user SYS is not permitted to create indexes with freelist groups Cause: user tried to create an index while running with sys authorization. Action: None ORA-02004: security violation Cause: This error code is never returned to a user. It is used as a…

Oracle 11g Error Codes and Solution Suggestions from ORA-01900 to ORA-02000 ORA-01900: LOGFILE keyword expected Cause: keyword missing Action: supply missing keyword ORA-01901: ROLLBACK keyword expected Cause: keyword missing Action: supply missing keyword ORA-01902: SEGMENT keyword expected Cause: keyword missing Action: supply missing keyword ORA-01903: EVENTS keyword expected Cause: keyword missing Action: supply missing keyword…

Oracle 11g Error Codes and Solution Suggestions from ORA-01800 to ORA-01900 ORA-01804: failure to initialize timezone information Cause: The timezone information file was not properly read. Action: Please contact Oracle Customer Support. ORA-01841: (full) year must be between -4713 and +9999, and not be 0 Cause: Illegal year entered Action: Input year in the specified…

Oracle 11g Error Codes and Solution Suggestions from ORA-01700 to ORA-01800 ORA-01702: a view is not appropriate here Cause: Among other possible causes, this message will be produced if an attempt was made to define an Editioning View over a view. Action: An Editioning View may only be created over a base table. ORA-01704: string…

Oracle 11g Error Codes and Solution Suggestions from ORA-01600 to ORA-01700 ORA-01600: at most one “string” in clause “string” of string Cause: The INIT.ORA parameter was mis-specified. Action: Correct the INIT.ORA parameter and restart the instance. ORA-01601: illegal bucket size in clause “string” of string Cause: The bucket size was invalid for this parameter. Action:…

Oracle 11g Error Codes and Solution Suggestions from ORA-01500 to ORA-01600 ORA-01500: failure in getting date/time Cause: During create database or alter tablespace, there was a failure in getting the date and time. Action: Contact your customer support representative. ORA-01501: CREATE DATABASE failed Cause: An error occurred during create database Action: See accompanying errors. ORA-01502:…

Oracle 11g Error Codes and Solution Suggestions from ORA-01401 to ORA-01500 ORA-01409: NOSORT option may not be used; rows are not in ascending order Cause: Creation of index with NOSORT option when rows were not ascending. For non-unique indexes the rowid is considered part of the index key. Therefore, if you create an index nosort…

Oracle 11g Error Codes and Solution Suggestions from ORA-01301 to ORA-01400 ORA-01301: error writing to file during flat file build Cause: Error writing to file during flat file build Action: None ORA-01302: dictionary build options missing or incorrect Cause: Missing dictionary build options or incorrectly specified options Action: Specify either a build to redo log…