OraFAQ Forum: Server Utilities » Is Datapump Export is Possible in Oracle Client

Home » RDBMS Server » Server Utilities » Is Datapump Export is Possible in Oracle Client (Oracle, 11g, windows 2008R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is Datapump Export is Possible in Oracle Client [message #627398]

Tue, 11 November 2014 10:29

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

Report message to a moderator

Re: Is Datapump Export is Possible in Oracle Client [message #627399 is a reply to message #627398]

Tue, 11 November 2014 10:36

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

No, it is not. However, you can use the older "exp" and "imp" utilities instead.

HTH
-g

Report message to a moderator

Re: Is Datapump Export is Possible in Oracle Client [message #627401 is a reply to message #627398]

Tue, 11 November 2014 12:03

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Is Datapump Export is Possible in Oracle Client [message #627402 is a reply to message #627399]

Tue, 11 November 2014 12:06

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Is Datapump Export is Possible in Oracle Client [message #628773 is a reply to message #627402]

Fri, 28 November 2014 05:49

Subbu19
Messages: 15
Registered: July 2014
Location: Chennai

Junior Member

Understood Michel. Thanks a lot.

Thanks gazzag

Report message to a moderator

Previous Topic:	Multiple "Include" in impdp
Next Topic:	Data pumps import issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 20:09:33 CST 2025