ISSUE:
data pump can not create files in directory created for mapping drive like S:\test_dir on windows.
CAUSE:
Mapping drive is specific for each account. The mapping drive like S:\test_dir must be recognized by the account running oracle service.
SOLUTION:
1. make sure the mapping drive you specified in " create directory statement" is available as the same mapping drive for the account running the oracle service. You can check services->properties -> logon to find the account name.
2. use direct network drive name like \\192.168.1.3\shearplace\testdir
SQL: create directory test_dir as '\\192.168.1.3\shearplace\testdir';
reference:
https://forums.oracle.com/message/9981090
No comments:
Post a Comment