Re: Oracle DataPump

haganahtrainer_at_gmail.com wrote:
> Situation:
>
> The QA department performs oracle exp/imp from one oracle server to
> another- this is done from a central client where the oracle client
> software is installed and there is no need to have physical access to
> the oracle database server.
>
> Is there a way to perform datapump operations in this fashion? It
> seems that to use datapump you need physical access to the database
> server which would mean copying export files from one database server
> to another... not very efficient.
>
> I really think datapump is faster than the old exp/imp utility and I
> would like to start using this, but I am not sure if this will cause a
> bottleneck in our current process...
>
> In closing, is there a way to use datapump using a "Central" client to
> perform the operations from one database instance to another???
>

Whichever way it is done, it has to traverse the network at some point. Why do you say "not very efficient"?
Have you tried expdp, ftp/scp and impdp? How much data are they transferring? Is it the entire database? Have you considered RMAN?
How much data is there to transfer? What is the acceptable time frame? How fast is your network?

Palooka Received on Thu Oct 30 2008 - 17:07:10 CDT