sqlldr load data in selective columns and skip not null columns in table
Hello there,
I need help while using sql loader. I am using sql loader to append data into existing table which has 20 columns and 6 columns are not null. Sql loader data file/infile contains data for only 4 columns. I am getting ora-01400 can not insert null value error - Can we skip those 5 columns and only insert data for 4 columns which don't have any constraints?
For eg. need to load data for only TEST_ID, SIGN_IN_COUNT, TEST_TOKEN, UN_EMAIL columns
and datafile contains:
123; 10; 3454; test1@test.com
234; 11; 3455; test2@test.com
345; 12; 3456; test3@test.com
456; 13; 3457; test4@test.com
SQL> desc foo.test1