Re: Oracle DataPump
Date: Thu, 30 Oct 2008 14:14:43 -0700 (PDT)
On Oct 30, 1:47 pm, haganahtrai..._at_gmail.com wrote:
> 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???
> Thanks !
No, but http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm#i1011008 lets you have it wind up on the server you want.
You might look into create table (or insert) as select over a dblink to get stuff there more directly. Depending on how much and how complicated the data is.
-- @home.com is bogus. http://lumenlab.com/2008/10/pumpkin/Received on Thu Oct 30 2008 - 16:14:43 CDT