Home » RDBMS Server » Server Utilities » Is Datapump Export is Possible in Oracle Client (Oracle, 11g, windows 2008R2)
Is Datapump Export is Possible in Oracle Client [message #627398] Tue, 11 November 2014 10:29 Go to next message
Subbu19
Messages: 15
Registered: July 2014
Location: Chennai
Junior Member
Hi Admin,
Is datapump export/Import is possible in Oracle client. If it possible, whether it has some special configuration?


Thanks,
Subbu
Re: Is Datapump Export is Possible in Oracle Client [message #627399 is a reply to message #627398] Tue, 11 November 2014 10:36 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
No, it is not. However, you can use the older "exp" and "imp" utilities instead.

HTH
-g
Re: Is Datapump Export is Possible in Oracle Client [message #627401 is a reply to message #627398] Tue, 11 November 2014 12:03 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

At the opposite of old export which makes the export job on the workstation that started it, Data Pump has 2 parts: expdp program which can run the client workstation, and a server part which actually executes the export on the instance server.
So if the question is "can I start a Data Pump job on a client?", the answer is yes.
But if the question is "can I have the Data Pump job executes on the client, and so the export dump file on the client?", the answer is no.

Re: Is Datapump Export is Possible in Oracle Client [message #627402 is a reply to message #627399] Tue, 11 November 2014 12:06 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

As a side note to gazzag's answer, the old export is no more upgraded, since 10g, and so does not support the new datatypes and new objects. Be sure if you use it, to not have any of these ones.

Re: Is Datapump Export is Possible in Oracle Client [message #628773 is a reply to message #627402] Fri, 28 November 2014 05:49 Go to previous message
Subbu19
Messages: 15
Registered: July 2014
Location: Chennai
Junior Member
Understood Michel. Thanks a lot.

Thanks gazzag
Previous Topic: Multiple "Include" in impdp
Next Topic: Data pumps import issue
Goto Forum:
  


Current Time: Wed Jun 19 03:46:03 CDT 2019