This content has been marked as final. Show 2 replies
In Oracle 11g you can create an external job to do that for you.
Another solution is to map the external location to a local drive and write the file directly there.
You have many options like :-
You can use, if you are using sql script then after generating .dat file you can use HOST command and type windows COPY command.
You can FTP the file by appling wait event for bat file. this is not part of oracle.
You can use bat file to copy and past the file to other server againt this is windows command.
Using UTL_FILE package by mapping the required path.