Using SQL*Plus to connect to remote DB from local server, how do I export a backup to my local server?
Datapump uses directory objects in the database, not direct file system paths. It can only export/import from directories visible on the database server itself. Your only possible option would be to share a directory from your local server to the database server and have Oracle write to the shared folder, but that doesn't always work either depending on the share type (plus it would be a pretty big security risk). Using datapump there is no way to export to a client system the way you are trying to do.