I am thinking to automate a manual work that i do on dailybasis.
It's all of loading the file data into a external table.
Is there any way that we can create OR replace external table as how we do for normal table ? I dont see the syntax of it any where?
Today if have loaded file 1 and tomorrow if i have to load file 2 for same table..I have to add this file 2 to already exsisting data in in external table