SQL Loader

From: Sackwitz, Antje <Antje.Sackwitz_at_ppi.de>
Date: Tue, 16 Jul 2002 00:58:21 -0800
Message-ID: <F001.00498D20.20020716005821@fatcity.com>

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:antje.sackwitz_at_ppi.de
  web	www.ppi.de

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sackwitz, Antje
  INET: Antje.Sackwitz_at_ppi.de

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: ListGuru_at_fatcity.com (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).

Received on Tue Jul 16 2002 - 03:58:21 CDT