Oracle Database Errors or Warnings from Error ORA-01381 to ORA-01406



ORA-01381: Dropping log string would leave less than two log files with block size string for instance string (thread string)
Cause: The database was migrated to use a specified log block size. Dropping all the logs specified would leave fewer than the required two log files with the specified block size per enabled thread.
Action: Either drop fewer logs or disable the thread before deleting the logs. It may be possible to clear the log rather than drop it.
ORA-01382: Thread string failed to open log file string. The log file’s block size (string) is larger than the disk sector size (string)

Cause: Log file was created on bigger sector disks, and moved to smaller sector disks.
Action: Move the log file back to bigger sector disks.
ORA-01383: Thread string failed to open string block size log file ‘string’ on string sector native-mode disks
Cause: Log file was copied from smaller sector disks to larger sector native-mode disks.
Action: Move the log file back to smaller sector disks.
ORA-01400: cannot insert NULL into (string)
Cause: An attempt was made to insert NULL into previously listed objects.
Action: These objects cannot accept NULL values.

ORA-01401: inserted value too large for column
Cause: The value inserted was too large for the given column.
Action: Do not insert a value greater than what the column can hold.
ORA-01403: no data found
Cause: No data was found from the objects.
Action: There was no data from the objects which may be due to end of fetch.
ORA-01406: fetched column value was truncated
Cause: The fetched column values were truncated.
Action: Use the right data types to avoid truncation.

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

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 *