OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » SQL LOAD

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL LOAD [message #452763]

Fri, 23 April 2010 18:53

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.

Report message to a moderator

Re: SQL LOAD [message #452765 is a reply to message #452763]

Fri, 23 April 2010 19:26

Barbara Boehmer
Messages: 9102
Registered: November 2002
Location: California, USA

Senior Member

Use FILLER and make it any name you like for the column name, like:

filler1 FILLER

Report message to a moderator

Re: SQL LOAD [message #452766 is a reply to message #452763]

Fri, 23 April 2010 19:29

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: SQL LOAD [message #452820 is a reply to message #452765]

Sat, 24 April 2010 23:34

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

Report message to a moderator

Re: SQL LOAD [message #452821 is a reply to message #452820]

Sat, 24 April 2010 23:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Please reply
post results showing what happened when you tried it.

Report message to a moderator

Re: SQL LOAD [message #452831 is a reply to message #452820]

Sun, 25 April 2010 04:23

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: SQL LOAD [message #452993 is a reply to message #452820]

Mon, 26 April 2010 13:03

joy_division
Messages: 4963
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.

Report message to a moderator

Re: SQL LOAD [message #453026 is a reply to message #452993]

Mon, 26 April 2010 14:48

Littlefoot
Messages: 21823
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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 05:31:17 CST 2025