We’re running TOAD for Oracle 22.214.171.124 with Oracle 11g on a Database Server.
We log in on an application server via TOAD.
I wish to create a DMP file that is scheduled every week that is kept on the application server in a specific directory. I thought I would be able to do this via Automation designer. So I created a Data Pump Export in Automation server:
Selected schems and the schema I wished to DMP. Under the files tab, I can not enter a path for the dmp or log file. I can only choose the data_pump_dir or other oracle areas - I assume those would be on the database server.
Is there any way to accomplish what I would like to do, whether it be a different method in Automation Designer or some other way?