LOAD DATA INFILE * APPEND INTO TABLE BIN_OBJ_TAB FIELDS TERMINATED BY ':' OPTIONALLY ENCLOSED BY '"' ( bin_obj_id "nvl(:bin_obj_id, bin_obj_seq.nextval)", object_id, name, user_id "nvl(:user_id, user)", privs, obj_type, obj_sub_type, file_type, file_obj, file_size, cre_date "nvl(:cre_date, sysdate)", mod_date "nvl(:mod_date, sysdate)" ) BEGINDATA :-1:ssc_group-a.csv::3:MODEL:SSC_GROUP_A:CSV:ssc_group-a.csv:981::: :-1:ssc_group-b.csv::3:MODEL:SSC_GROUP_B:CSV:ssc_group-b.csv:1028::: :-1:ssc_group-c.csv::3:MODEL:SSC_GROUP_C:CSV:ssc_group-c.csv:1022:::