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

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.

eg:
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
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
when all else fails, you could try reading the fine Utilities Manual
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm
Re: query regarding sqlldr [message #213788 is a reply to message #213084] Fri, 12 January 2007 05:26 Go to previous message
rahul_bahulekar
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.

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


Current Time: Tue Dec 06 02:18:31 CST 2016

Total time taken to generate the page: 0.09064 seconds