Home » RDBMS Server » Server Utilities » SQL*Loader
SQL*Loader [message #368274] Wed, 25 October 2000 00:30 Go to next message
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-follow this URL [message #368279 is a reply to message #368274] Wed, 25 October 2000 12:24 Go to previous messageGo to next message
Messages: 144
Registered: March 1999
Senior Member
Re: SQL*Loader [message #368281 is a reply to message #368274] Wed, 25 October 2000 13:28 Go to previous message
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.

Previous Topic: SQL*Loader
Next Topic: sql*plus
Goto Forum:

Current Time: Wed Jun 07 01:51:26 CDT 2023