Home » RDBMS Server » Server Utilities » query regarding sqlldr
query regarding sqlldr [message #213084] Tue, 09 January 2007 07:39 Go to next message
Messages: 1
Registered: January 2007
Junior Member

i need to insert records into one table from a delimited text file using sqlldr.

but the problem is, i don't need all the fields in the text file to insert into table.

The structure of the text file is:

[ssn Name job comp_name sal ]
7782, "Clark", "Manager", "amdocs", 2572.50

i hav table with 4 columns. i.e. ssn, name, job, sal (excluding comp name)

while inserting the above record into the table, i need to skip that comp name field using sqlldr.

how to skip this n what to mention in the control file.

Re: query regarding sqlldr [message #213120 is a reply to message #213084] Tue, 09 January 2007 09:42 Go to previous messageGo to next message
Messages: 25473
Registered: January 2009
Location: SoCal
Senior Member
when all else fails, you could try reading the fine Utilities Manual
Re: query regarding sqlldr [message #213788 is a reply to message #213084] Fri, 12 January 2007 05:26 Go to previous message
Messages: 18
Registered: January 2007
Junior Member
Hi Sandeep,

to exclude comp_name, you can put filler for comp_name in control file.

comp_name filler

hope this will help you.

Previous Topic: Using Data Pump in Oracle 10g?
Next Topic: problems with TimeStamp
Goto Forum:

Current Time: Thu Jun 22 13:37:18 CDT 2017

Total time taken to generate the page: 0.12483 seconds