Re: Oracle DataPump

On Oct 30, 11:07 pm, Palooka <nob..._at_nowhere.com> wrote:
> haganahtrai..._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

I'd like to throw in transportable tablespaces as an option. Regards, Erik Received on Sun Nov 02 2008 - 15:23:53 CST