Oracle database error code ORA-26009 – NOT NULL column string has a defaultif clause which may evaluate to null

Oracle Database Error Code ORA-26009 Description :
NOT NULL column string has a defaultif clause which may evaluate to null
Error Cause:
A column which is NOT NULL in the database has a SQL*Loader DEFAULTIF clause which may evaluate to null.

How to Solve :
Remove the DEFAULTIF clause in the SQL*Loader control file.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»