How to export large table data into different files in oracle?
You should probably use utl_file and a for loop for this assignment. Then you can open and write one line per file. You should also let people know what a Lakh line is.