CODEWITHSUNDEEP
oracle-database
sameer karjatkar
sameer karjatkar

Reputation: 2057

Oracle data pump

I am using Oracle Export data pump (expdp) for my application . My oracle client and server are on different machines . When I use my application which is on the oracle client machine , the exported dump is always created on the Oracle server machine . Is this the oracle export data pump limitation ? Or Is there a workaround ?

Upvotes: 0

Views: 259

Answers (1)

DazzaL
DazzaL

Reputation: 21973

thats the way datapump works by design.

If you need client side, you have to use the older exp and imp. otherwise use datapump and ftp the file to your local machine afterwards.

http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#i1010293

Note: All Data Pump Export and Import processing, including the reading and writing of dump files, is done on the system (server) selected by the specified database connect string. This means that for unprivileged users, the database administrator (DBA) must create directory objects for the Data Pump files that are read and written on that server file system.

Upvotes: 2

Related Questions