Home » RDBMS Server » Server Utilities » SQL LOAD
SQL LOAD [message #452763] Fri, 23 April 2010 18:53 Go to next message
singhabm
Messages: 4
Registered: July 2007
Location: India
Junior Member

Hi All,

I have a file with 5 columns like:
001 David 40 1234567 RTS
002 Franc 20 999889 MBQ
003 Ralph 30 8876599 ITD

I have to load this file into table which has only four columns
which are:
describe emp
name varchar2 (25),
deptno number,
lan_number number (10),
Irc_code varchar2 (20)

So for this I have to remove the first columns from the file.

Is there any way I can do it by using sql loader?
What condition should I specify in control file ?
I think for using filler, column name must be specified.

Please reply and thanks in advance.
Re: SQL LOAD [message #452765 is a reply to message #452763] Fri, 23 April 2010 19:26 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8919
Registered: November 2002
Location: California, USA
Senior Member
Use FILLER and make it any name you like for the column name, like:

filler1 FILLER
Re: SQL LOAD [message #452766 is a reply to message #452763] Fri, 23 April 2010 19:29 Go to previous messageGo to next message
BlackSwan
Messages: 26648
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/wiki/SQL*Loader_FAQ

I am sorry to see SEARCH of this forum is broken for you.
Bring up page above & SEARCH for FILLER
Re: SQL LOAD [message #452820 is a reply to message #452765] Sat, 24 April 2010 23:34 Go to previous messageGo to next message
singhabm
Messages: 4
Registered: July 2007
Location: India
Junior Member

Hi,

Thanks for the quick reply..

i have a concern that by adding
filler_1 filler
in my control file, do i have to alter my table.
because my table emp has 4 columns but file has 5 columns.

Please reply
Re: SQL LOAD [message #452821 is a reply to message #452820] Sat, 24 April 2010 23:41 Go to previous messageGo to next message
BlackSwan
Messages: 26648
Registered: January 2009
Location: SoCal
Senior Member
>Please reply
post results showing what happened when you tried it.
Re: SQL LOAD [message #452831 is a reply to message #452820] Sun, 25 April 2010 04:23 Go to previous messageGo to next message
Littlefoot
Messages: 21528
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator

Filler column[ 7 votes ]
1. Yes, we have to alter a table and add another (filler) column 3 / 43%
2. No, we don't have to alter a table 4 / 57%

As it is impossible to perform that difficult task (i.e. test it), perhaps we should vote.

Re: SQL LOAD [message #452993 is a reply to message #452820] Mon, 26 April 2010 13:03 Go to previous messageGo to next message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
singhabm wrote on Sun, 25 April 2010 00:34
Hi,

Thanks for the quick reply..

i have a concern that by adding
filler_1 filler
in my control file, do i have to alter my table.
because my table emp has 4 columns but file has 5 columns.

Please reply


I would re-read Barbara's post. It should be clear.
Re: SQL LOAD [message #453026 is a reply to message #452993] Mon, 26 April 2010 14:48 Go to previous message
Littlefoot
Messages: 21528
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Gee, it literally takes a few minutes to perform that test. There's really no need to be worried about it or have doubts as it is just too freaking simple to try it.

I wonder if that silly "Yes" vote scared the OP away from filler.
Previous Topic: Import Performance using sql *loader
Next Topic: Re: "field in datafile exceeds maximum length" for number field (splilt from hijacked thre
Goto Forum:
  


Current Time: Fri Jan 17 23:28:13 CST 2020