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…
Tag: Oracle Error Solutions
Oracle 11g Error Codes and Solution Suggestions from ORA-01600 to ORA-01700
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
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
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
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…
Oracle 11g Error Codes and Solution Suggestions from ORA-01201 to ORA-01300
Oracle 11g Error Codes and Solution Suggestions from ORA-01201 to ORA-01300 ORA-01201: file string header failed to write correctly Cause: An I/O error was reported for the file header. The error was trapped and a second attempt will be made. Action: The file probably will require recovery. Further error messages will indicate what is needed….
Oracle 11g Error Codes and Solution Suggestions from ORA-01101 to ORA-01200
Oracle 11g Error Codes and Solution Suggestions from ORA-01101 to ORA-01200 ORA-01101: database being created currently mounted by some other instance Cause: Some other instance has the database of same name currently mounted and you are trying to create it. Action: Either change the database name or shutdown the other instance. ORA-01102: cannot mount database…
Oracle 11g Error Codes and Solution Suggestions from ORA-01000 to ORA-01100
Oracle 11g Error Codes and Solution Suggestions from ORA-01000 to ORA-01100 ORA-01002: fetch out of sequence Cause: This error means that a fetch has been attempted from a cursor which is no longer valid. Note that a PL/SQL cursor loop implicitly does fetches, and thus may also cause this error. There are a number of…
Oracle 11g Error Codes and Solution Suggestions from ORA-00900 to ORA-01000
Oracle 11g Error Codes and Solution Suggestions from ORA-00900 to ORA-01000 ORA-00910: specified length too long for its datatype Cause: for datatypes CHAR and RAW, the length specified was > 2000; otherwise, the length specified was > 4000. Action: use a shorter length or switch to a datatype permitting a longer length such as a…
Oracle 11g Error Codes and Solution Suggestions from ORA-00801 to ORA-00900
Oracle 11g Error Codes and Solution Suggestions from ORA-00801 to ORA-00900 ORA-00820: Specified value of sga_max_size is too small, needs to be at least string Cause: The specified value of sga_max_size is too small for the SGA to accommodate all of the necessary SGA components such as the log buffer, buffer pools, shared pool, etc….