I want to copy a file from server to my client machine. Can I use dbms_scheduler.put_file for this action. And if your answer is yes how can I do this.
Or your answer is no why can' t I do and how can I copy file from server to my client?
Probably yes. It is new feature of 11R2 I never saw this function before.
Check documentation for details.
But in general you DB server must have access to you client machine via network -> you have to create some shared network folder on you local machine and make it accessible for user under which DB is running on your server.
The UNIX user set up for the Oracle Database does not have access to the directories, so a CREDENTIAL has been set up using a different UNIX user which does have this access. This is a security feature which allows us to limit access to the UNIX server.
This is not exactly what you are asking for ... but maybe you can modify it to meet your needs. Is there a UNIX command that would let you copy from the server to your client? All I can think of is FTP