Hi all, I have a problem with this export datapump and I use network_link parameter.
What I want:
_ Use data pump to export dmp file from Server (linux) to Client (windows)
What I got:
_ It doesn't understand path file. This below img just example path 'C:/export'
What I did:
1/ Have a user QIP/QIP with full priviles from sys, SID=Q11G, IP**: 192.168.88.212 -** all on linux server.
2/ Use QIP to create Directory datapump with local path 'C:' (on client Windows - administrator, not server Linux).
>> create directory datapump as 'C:';
3/ Create a database link with name expdp_out for user QIP identified QIP using 'hostname:port/SID'. I created 2 dblink to test clearly:
>> create database link expdp_out connect to qip identified by qip using '192.168.88.212:1521/q11g';
>> create database link expdp_out2 connect to qip identified by qip using 'q11g';
4/ Try to export data pump from client with 2 cmd:
>> expdp qip/qip@Q11G DIRECTORY=datapump DUMPFILE=export_out.dmp nologfile=y TABLES=audit_event network_link=expdp_out
>> expdp qip/qip@Q11G DIRECTORY=datapump DUMPFILE=export_out.dmp nologfile=y TABLES=audit_event network_link=expdp_out2
So, I catch errors in the above img, but in this case ORA-31641 is just "C:/export_out.dmp"
I cannot control the linux path for dump file from "/" to "\" like windows path. Please help, thank you