How to export large table data into different files in oracle? I have a table which contains 1 million lines and need to export into different files which containing 100k lines each.
sample_01.sql ,sample_02.sql and so on
How can we take export like this 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.