I need to create CSV file for more than 1m records from the database. Please suggest which method will be efficient one.
I tried to spool the data using sqlplus but it took 70 minutes to complete this. Use of Utl_file package will help here? Or any other way to reduce the time to export these data to the CSV file.
The file generation will happen on user request from the application so I need this to be done as quick as possible.
Thanks in advance.