So would I have to write 2 CTL files........
one to truncate the table and one to load the new data...
as when I try to do both in one - It just errors....
Hi
please find below A control file which I have loaded successfully - I now want to append into it -but have decided that each I run it I would rather trncate the table first and then load the data into it - how can I do this?
LOAD DATA
APPEND INTO TABLE px_extract
FIELDS TERMINATED BY ","...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.