Oracle-L: RE: SQL Loader

From: <cosltemp-g.manoj_at_orbitech.co.in>
Date: Tue, 16 Jul 2002 04:53:36 -0800
Message-ID: <F001.00498F3A.20020716045336@fatcity.com>

Hi,

first remove the millisec part & AM part.

Apply sql string to the col Date_date:

to_date('Jan 1 2002 12:00:00','Mon dd yyyy hh:mi:ss')

assume pos of Jan 1 2002 12:00:00:000AM is 15

Note : do not use Date_date in Oracle as date is data type.

rename it e.g Cal_dt

sample control file :

load data
infile
insert
into table calendar
(

Date_date position(15:35) "to_date(:Date_date,'Mon dd yyyy hh:mi:ss')", ....other cols
)

-----Original Message-----
Sent: Tuesday, July 16, 2002 2:28 PM
To: ORACLE-L
Cc: Antje.Sackwitz

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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: cosltemp-g.manoj_at_orbitech.co.in

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 - 07:53:36 CDT