The joys of UNIX-style operating systems.
There's always a way to do what you want. It just might take you forty years to fine the correct options
The really sad thing is I've used that import method before (years ago) and I completely forgot. Chump.
you can check note 191043.1
you can even define "-" as stdin in the controlfile then do
INTO TABLE LDR_TEST
FIELDS TERMINATED BY ";"
cat $1 | sqlldr scott/tiger control=LDR3.CTL
This is how my control file look like.
into table test
fields terminated by ' '
Click Here to Expand Forum to Full Width