Brian, Yes, you are right. Example: create table test(col1 number, col2 date); cat test.dat 1 2 3 4 5 cat test.ctl load data infile 'test.dat' badfile 'test.bad' discardfile 'test.dsc' into table TEST insert fields terminated by ',' (COL1, COL2 SYSDATE) Alisher Yuldashev Senior Oracle DBA www.pythian.com Zelli, Brian wrote:
Ok, I've gone completely brain-dead. I need to add a date column to my sqlload control file, I just use sysdate correct? If it's not part of my input file that's ok right? As long as I have a column named for it on the table I'm loading? Brian