you can check note 191043.1
you can even define "-" as stdin in the controlfile then do
Code:LOAD DATA INFILE "-" TRUNCATE INTO TABLE LDR_TEST FIELDS TERMINATED BY ";" ( ID, TEXT ) cat $1 | sqlldr scott/tiger control=LDR3.CTL
|
Results 1 to 10 of 13
Thread: loading zip files.Threaded View
|
Click Here to Expand Forum to Full Width |