I am using Toad for Data Analysts (v. 184.108.40.2063) and I have a question about the Select to File option for the Automate section.
I am connecting to an Oracle database. My task is to run ~300 separate queries and export the results from each to its own CSV file. I’ve tried creating the Automate routine (see attached), but when I try to run it for a subset of the 300 (e.g. like the 10 in the screenshot), the Automate action fails and I receive the following error from Oracle:
ORA-02391: Exceeded simultaneous SESSIONS_PER_USER limit
Not sure what to do now. Are the queries being executed in parallel or series by the Automate module? Is there a better way to do this task?