| SQL*Loader [message #368274] |
Wed, 25 October 2000 00:30  |
Martin Cadman
Messages: 3
Registered: October 2000
|
Junior Member |
|
|
I have no control over the generation of the flat file, and each row contains fields I do not want to import. The files are | delimited, not fixed length.
Am I able to missout/skip a data field completely?
|
|
|
|
|
|
| Re: SQL*Loader [message #368281 is a reply to message #368274] |
Wed, 25 October 2000 13:28  |
Thaniks
Messages: 8
Registered: October 2000
|
Junior Member |
|
|
Hi Martin Cadman,
If you don't get solution from anyone, you can load the flat file data into a temporary table as it is and after that you can insert the required columns into your original target table.
This is one of the solutions to manage the situation right now.
Thaniks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
