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
Andrew
Messages: 144
Registered: March 1999
Senior Member
http://osi.oracle.com/~tkyte/SkipCols/
Re: SQL*Loader [message #368281 is a reply to message #368274] Wed, 25 October 2000 13:28 Go to previous message
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.
Previous Topic: SQL*Loader
Next Topic: sql*plus
Goto Forum:
  


Current Time: Thu Mar 28 06:15:41 CDT 2024