Home » RDBMS Server » Server Utilities » Sqlloader with skip columns (oracle9i)
Sqlloader with skip columns [message #379455] Tue, 06 January 2009 10:20 Go to next message
shrinika
Messages: 267
Registered: April 2008
Senior Member
Hello, I have one issue for loading data in oracle table through sqlloader utility.

My issue here is, I am receving the data file from SAP environment. The data file content
is delimited with pipe sign.

Some time, in SAP side, they might add new columns. So in the text file, they include those new columns.
But in my database, we don't add those new columns. Is there any way, i can load the data...

For instance, We have text file with folling columns..

Field1 Field2 Field3 Field4 Field5
120|893|Mike|sam|34

In the database, we have only the below fields.

Field1
Field2
Field3


How can i avoid Field4 & Field5 from the text file.

My only option is, we can add new fields in the table and use FILLER option to avoid the new columns...
But is there any other option with out adding the new columns in the table??

I would appreciate if any one can help me on this...





Re: Sqlloader with skip columns [message #379458 is a reply to message #379455] Tue, 06 January 2009 10:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What happens when you tried to load a file with 5 fields when there are only 3 defined in SQL*Loader control file?

Regards
Michel
Re: Sqlloader with skip columns [message #379464 is a reply to message #379455] Tue, 06 January 2009 11:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can use filler without adding new columns in table.
http://www.orafaq.com/forum/m/73116/42800/#msg_73125
Re: Sqlloader with skip columns [message #379476 is a reply to message #379458] Tue, 06 January 2009 12:50 Go to previous message
shrinika
Messages: 267
Registered: April 2008
Senior Member
Michel, It works when i tried to load a file with 5 fields when there are only 3 defined in SQL*Loader control file.
I am sorry for posting this without testing... Sorry again.

[Updated on: Tue, 06 January 2009 12:51]

Report message to a moderator

Previous Topic: Date formatting in SQL Loader
Next Topic: Sqlldr Date Issues
Goto Forum:
  


Current Time: Sat Dec 10 08:50:47 CST 2016

Total time taken to generate the page: 0.07371 seconds