All my DB interaction actions connected to lets say "NJSP1" DB Instance. Since IT upgraded Oracle and DB environment, I got moved to "NJSPAUD" DB instance.
I have to go into each import/export and other actions and change the DB instance. Since NJSP1 no longer exists, I select the action and properties and a Schema/Password/DB dialog prompts me to enter new credentials.
#1 - is there a way to do this without touching every actions that requires DB interaction?
#2 - I tried manually changing the DB and I get "ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit" after 4 or 5 action updates. How do I get around this as well?
Thanks in advance.