I need to automate via script ending connection to database between Create Table actions in my Automation App. I get a script error “ORA-02394: exceeded session limit on IO usage, you are being logged off”. I noticed that if I run each Create Table actions one at a time that they Complete just fine. I need the App to do both Create Tables back to back via scheduled automation.
I’m thinking if the App can run one create table, then end connection, then the 2nd create table will start a new connection automatically