Transfer csv file from DB server to MWS

Are you running Windows? If so, you can write directly to the MWS without needing to copy the file first.

Oracle Database runs as the SYSTEM user by default, but on the network, that means it runs as the corresponding Computer principal in Active Directory. If the server hostname is DBSERVER, then Oracle would run as a user called DBSERVER$ (with a dollar sign on the end). You can grant folder access to that Computer principal to allow Oracle to write to a UNC path.

First, you’ll create your share on the middleware server.

\\your_middleware_server\share_name

 Next, you’ll grant that share to the user running Oracle. Here’s what that grant screen might look like in Windows:

Finally, you’ll create your directory object in Oracle:

CREATE OR REPLACE DIRECTORY your_directory AS '\\your_middleware_server\share_name';

GRANT ALL PRIVILEGES ON DIRECTORY your_directory TO ifsapp;

Footnote:

Oracle recommends you run their software as a regular user instead of this default of using the SYSTEM user. I suspect it’s because this mapping from SYSTEM to a Computer principal isn’t obvious, and I also suspect they’re expecting you to run more than just Oracle Database on that machine. If you’re willing to say Oracle Database owns that machine, then I don’t see a problem with keeping the default user as SYSTEM.