This content has been marked as final. Show 6 replies
Pls post the dw_mc_targets DDL script
create table DW_MC_TARGETS ( LOC_LOC_ID VARCHAR2(10), YYYYWW VARCHAR2(6), BC_TARGET VARCHAR2(20), OIS_TARGET VARCHAR2(20), HOF_COM_TARGET VARCHAR2(20), HOF_COM_STRETCH_TARGET VARCHAR2(20) ) tablespace DIM_TAB1 pctfree 10 pctused 40 initrans 1 maxtrans 255 storage ( initial 1M next 1M minextents 1 maxextents 500 pctincrease 0 );
I tired it's wroking for me
LOAD DATA INFILE * APPEND INTO TABLE DW_MC_TARGETS FIELDS TERMINATED BY "," TRAILING NULLCOLS ( LOC_LOC_ID, YYYYWW, BC_TARGET, OIS_TARGET, HOF_COM_TARGET, HOF_COM_STRETCH_TARGET ) BEGINDATA 0450,201201,9014.95,2069.21,,,,, 0450,201202,8000.77,2022.64,,,,, 0450,201203,7155.62,2003.41,,,,, 0450,201204,7437.33,2064.81,,,,, 0450,201205,8282.49,2036.46,,,,,
Check the database alert log. Direct path insert writes above the current high water mark for the table, so there may be an issue when it tires to allocate further extents to the table.
Although it's working for someone (might not be the same version as yours)
Eight commas in your data make room for nine columns (trailing nullcols specified) but you're defining only six columns (and there's no IGNORE IN-EXCESS DATA keyword available)
It was High water Mark issue with this table...
Now it has done successfully means data has been loaded successfully.