| Sqlloader with skip columns [message #379455] |
Tue, 06 January 2009 10:20  |
shrinika
Messages: 306
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...
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
