How to fix the Oracle error ORA-26010: Column string in table string is NOT NULL and is not being loaded?

In this post, you’ll learn more about the Oracle ErrorORA-26010: Column string in table string is NOT NULL and is not being loaded with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26010: Column string in table string is NOT NULL and is not being loaded

Reason for the Error ORA-26010: Column string in table string is NOT NULL and is not being loaded

A column which is NOT NULL in the database is not being loaded and will cause every row to be rejected.

How to fix the Error ORA-26010: Column string in table string is NOT NULL and is not being loaded ?

You can fix this error in Oracle by following the below steps

Load the column by specifying the NOT NULL column in the INTO TABLE clause in the SQL*Loader control file.