Suppose, I have server machine named "NEPTUNE". In the server machine under /oradata2 directory there is a dump file named net.dmp. However to run import operation we need not connect to server "NEPTUNE" and then perform import operation. From any machine which have data pump import client can do the operation.
In this case we need to specify with username/password field a net service name. We can easily use easy name service method here.
Note that, The dump file, the directory are all in server. Only impdp client is on another machine from which I will invoke impdp utility.
In server machine "NEPTUNE" I invoked lsnrctl status and saw the listener port is 1522 and service name is ARJU. The dump file is /oradata2/net.dmp and a directory is there named as dimp.
From Another machine just invoke,
impdp arju/a@neptune:1522/ARJU directory=dimp dumpfile=net.dmp
Related Documents:
-------------------
Extract DDL from Dump
No comments:
Post a Comment