ora 01400

ORA-01400:	cannot insert NULL into (string)
Cause:	An attempt was made to insert a NULL into the column "USER"."TABLE"."COLUMN". For example, if you enter: connect scott/tiger create table a (a1 number not null); insert into a values (null); Oracle returns: ORA-01400 cannot insert NULL into ("SCOTT"."A"."A1") : which means you cannot insert NULL into "SCOTT"."A"."A1".
Action:	Retry the operation with a value other than NULL.

Error:	ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE_NAME"."COLUMN_NAME")
Cause:	You tried to insert a NULL value into a column that does not accept NULL values.
Action:	The options to resolve this Oracle error are: Correct your INSERT statement so that you do not insert a NULL value into a column that is defined as NOT NULL. For example, if you had a table called suppliers defined as follows: CREATE TABLE suppliers ( supplier_id number not null, supplier_name varchar2(50) not null ); And you tried to execute the following INSERT statement: INSERT INTO suppliers ( supplier_id ) values ( 10023 ); You would receive the following error message: You have defined the supplier_name column as a NOT NULL field. Yet, you have attempted to insert a NULL value into this field. You could correct this error with the following INSERT statement: INSERT INTO suppliers ( supplier_id, supplier_name ) values ( 10023, 'IBM' ); Now, you are inserting a NOT NULL value into the supplier_name column.

ORA-01400: cannot insert NULL error when importing data ora 01400

I exported a table that has blank (ie a single space) data in a column which is defined a not null.

When I try to import these data into a table I get the
error
ORA-01400: cannot insert NULL into ("SSYS"."PS_ACAD_PROG_TBL"."AMS_PROG_TYPE_GRP"

It looks like that the data that were blank in the export file is treated as NULL.