Oracle-L: RE: Oracle-L, SQL-loader

From: <cosltemp-g.manoj_at_orbitech.co.in>
Date: Thu, 18 Jul 2002 01:18:24 -0800
Message-ID: <F001.0049B0E8.20020718011824@fatcity.com>

To run sqlldr use below cmd at cmdprompt : sqlldr userid = "db_user" control="CTRLFILENM" data="INFO_CALENDAR.DMP"

u can remove infile entry from control file & can specify it above.(data = "datafilenm" as
mentioned above).
U can also move discardfile,discardmax entries & place it above.(discardfile="FNM"
discardmax=999)

-----Original Message-----
Sent: Thursday, July 18, 2002 1:19 PM
To: Manoj, COSLTEMP-G
Cc: Antje.Sackwitz

Hi,
can you please have a look:
Is the top part the correct syntax for the controlfile? How do I call the
loader? I am just irritated by the manual.

LOAD DATA
INFILE 'INFO_CALENDAR.DMP'
DISCARDFILE 'INFO_CALENDAR.DSC'
DISCARDMAX = 999
REPLACE
CONTINUEIF THIS (1) = '*'
INTO TABLE info_calendar
(

  Date_int        Postition(1:8)          int,
  Date_date       Position(10:35)         date 'Mon dd yyyy hh:mi:ss'
"RTRIM(:Date_date,':000AM')",
  Weekday_int     Position(36:37)         smallint,
  Weekday_str     Position(39:48)         varchar(16),
  DayOfYear_int Position(50:51)           smallint,
  Week_int      Position(53:55)           smallint,
  Month_int     Position(57:59)           smallint,
  Month_str     Position(61:70)           varchar(16),
  Quarter_int   Position(72:73)           smallint,
  Year_int      Position(75:79)           smallint,

YearOfWeek_int Position(81:85) smallint )

just for information

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

table INFO_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

)

  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: 
  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 Thu Jul 18 2002 - 04:18:24 CDT