Location: Data Import and Export

Discussion: Expdp Client side ?Reported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 2 posts
Alain.B.
Alain.B.
Expdp Client side ?
Aug 20 2008, 5:10 AM EDT | Post edited: Aug 20 2008, 5:10 AM EDT
Is there a way to use expdp from any client station and having the dumpfile also generated on that same station ?
Like old exp ?
 2  out of 2 found this valuable. Do you?    
Keyword tags: client side exp expdp export

astephan
1. RE: Expdp Client side ?
Aug 22 2008, 2:31 AM EDT | Post edited: Aug 22 2008, 2:31 AM EDT
Hi Alain,

if you manage to install exactly the same release of Oracle software on your client you should be able to use expdp to start/stop/pause/resume expdp jobs, since the expdp and impdp tools are only frontends to powerful packages and jobs running on the database. Since exporting is server based all output is done by the Oracle server processes on the DB server. You can of course create a directory object pointing to a nfs/samba (or if the db runs on win, on a ntfs share). If this share is located on your client you are done. But be prepared that writing export files across the network will increase export times significantly.

But to be honest - in my opinion it makes no sense to install expdp on a client computer. Every time you patch or upgrade your database you have to check for the same versions and patches for your client platform (if different). Better use ssh or terminal server client to run your expdp - or set up a job in GridControl or DBConsole and let you be informed by email about success or failures of the job.

Regargs
Andreas
 0  out of 1 found this valuable. Do you?    

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Data Pump.....and Compression? EXP & IMP only restores to same tablespace(s) OWB Export Projects Utility
Oracle export and import Help with Headers in Export File Data Pump Security
Data Import and Export Data Pump Export (expdp) and Data Pump Import(impdp)