I am trying to use expdp and impdp instead of exp and imp.
I am facing few issues while using expdb. I have a Job which exports data from one DB server and then its imported so another DB server. Both DB servers are run on separate machines. Job runs on various clients machine and not on any of DB server.
For using expdp we have to create DIRECTORY and as I understand it has to be created on DB server. Problem here is Job can not access DB Server or files on DB server. Also dump file created is moved by Job to other machines based on requirement( Usually it goes to multiple DB server).
I need way to create dump files on server where job runs.
If I am not using expdp correctly please guide. I am new to expdp/impdp and imp/exp.
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 220.127.116.11.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.
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 :(