This content has been marked as final. Show 6 replies
move to Oracle Discussion Forums » Oracle Database » General Questions rather than the SQL and PL/SQL forum, even after I told you which forum to post in
1. What is Db version and OS?
2. As you mention you need to create directory on db server to take export by using datapump utulity, than you can move those dmp from one server to another
Thanks for quick reply ..
Job executing expdb/impdp runs on Red Hat Enterprise Linux Server release 5.6 (Tikanga)
ORACLE server Release 18.104.22.168.0
Job can not access the ORACLE server as it does not have privileges (In fact there is no user / password to access ORACLE server machines). Creating dump on oracle server and moving is not an option for this JOB. It has to keep dump with itself.
an alternative is: impdp has the NETWORK_LINK option that will import data using a database link, without any dumpfile
(In fact there is no user / password to access ORACLE server machines)then how did you (job) connect with the traditional exp/imp?
Thanks for reply ..
I have DB Account details (DB user/ DB Password @Instance ) however to get physical file from ORACLE server I don't have any access.
In production environment Database servers access is strict No :(
Balazs' answer is correct - just use NETWORK_LINK - this does not create a file but transfers all the data over a database link.