Hi, can anyone please help with SQL Loader? I want to migrate a personal calendar from Sybase to Oracle. Template records in my Sybase bcp dump are 20020101 Jan 1 2002 12:00:00:000AM 3 Tuesday 1 1 1 January 1 2002 2002 20020102 Jan 2 2002 12:00:00:000AM 4 Wednesday 2 1 1 January 1 2002 2002
My Oracle-table has following columns: table Calendar ( Date_int number not null, Date_date date not null, Weekday_int number not null, Weekday_str varchar2(16) not null, DayOfYear_int number not null, Week_int number not null, Month_int number not null, Month_str varchar2(16) not null, Quarter_int number not null, Year_int number not null, YearOfWeek_int number not null ) How does my controlfile have to look? Especially with the date_format. Can I just provide the psotitions and leave out the Milliseconds and AM and PM values? Regards, Antje ____________________________ Antje Sackwitz ppi Media GmbH Deliusstraße 10 D-24114 Kiel phone +49 (0) 43 1-53 53-2 16 fax +49 (0) 43 1-53 53-2 22 email mailto:[EMAIL PROTECTED] web www.ppi.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).