Home » RDBMS Server » Server Utilities » SQLLDR..Delimited file: bypass unwanted data fields (2 threads merged by bb) (10.2.0.4B)
SQLLDR..Delimited file: bypass unwanted data fields (2 threads merged by bb) [message #563108] Wed, 08 August 2012 14:32 Go to next message
Clemente
Messages: 1
Registered: August 2012
Junior Member
using SQLLDR: Looking for a control file solution to move past or bypass extra data fields which are not on destination table. Basically if you have 8 tab delimited fields(terminated by '\t') on a data record; but only need to load 5 of the values from the delimited record; is there a way to ignore/bypass the not needed data. Obviously, the answer would be to massage the data at the OS and removed the 3 unnecessary fields. However my hands are tied by volume,time, and compliancy. I am familiar with using 'FILLER' for the reverse scenario; but not where you have more data available on the record then exists on the table. Hoping there is a ctl file parm or solution.

Appreciate the assist. Clemente
Re: SQLLDR..Delimited file: bypass unwanted data fields (2 threads merged by bb) [message #563111 is a reply to message #563108] Wed, 08 August 2012 15:00 Go to previous message
Barbara Boehmer
Messages: 7937
Registered: November 2002
Location: California, USA
Senior Member
FILLER is still the solution for what you are describing. If you have 8 fields in your data file and 5 columns that you want to populate in your table, then just use FILLER for the 3 fields that are not to be loaded.
Previous Topic: Load from a text file
Next Topic: expdp fails
Goto Forum:
  


Current Time: Mon Jul 28 11:53:17 CDT 2014

Total time taken to generate the page: 0.13197 seconds