Database Utilities (MOSC)

MOSC Banner

loading DATA with sql loader

edited Feb 3, 2012 3:01AM in Database Utilities (MOSC) 2 commentsAnswered
Hi all

I want ot load 600,000 records on table like

SQL> desc research.CLOSEDCASE_TEMP
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 CASENUMBER                                         CHAR(15)

with one flat file like this

318072018000024
318072018000025
318072018000026
318072018000029
318072018000030
318072018000031
318072018000034
318072018000036
318072018000040
318072018000041
318072018000042
318072018000047

so i was thinking to use the next commands and control file

sqlldr username/password@server control=loader.ctl

the loader.ctl file would have

load data
infile *
 into table RESEARCH.CLOSEDCASE_TEMP
 (   casenumber(01:15) char(15)
  )
begindata
BEGINDATA
11111AAAAAAAAAA
22222BBBBBBBBBBB

Regards

Jesus


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center