Datapump in remote location

Datapump in remote location


expdp in remote location (mapped drive)
===============================================
1. Use UNC naming convention (\\\) on CREATE DIRECTORY command.
For example: CREATE DIRECTORY dump_dir AS '\\mk0510backup\dumpRAC$\DUMPS\DP';
2. Shut down the database.
3. Stop the listener.
4. Modify the instance service (OracleService) to run as OS account that has the appropriate privileges to access the mapped network disk.
5. Modify the listener service to run as the same account.
6. Start the instance service and the database.
7. Start the listener service.
If after 7, the DB or the listener didn't start appropriately, then Reboot the machine.
(2 OS same User and Password (Cluster Server like) Oracle Services Run this user)
To identify that the OS account has the appropriate privileges to access the mapped network disk, copy a file to that directory from the command prompt:
copy

-----------------------------------------------------------------------
SQL> create or replace directory dir_expdp as '\\localserver\backup\';