Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

data pump directory

user11153253Feb 19 2014 — edited Feb 20 2014

Hi ,

can we give the location of other server file system (UNIX)or folder (windown) while creating datapump directory

for example my database server name is erpprod which is 11g R2 database  , and one more server named serv-wind which is  on windows and it has got directory ORAEXPDP in F drive like F:\ORAEXPDP

SQL> create Directory dump_dir1 as '\\serv-win\f:ORAEXPDP\';      (for windows)

or

SQL>create Directory dump_dir1 as '/other servername/u02/ORAEXPDP/';

thanks & regards.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2014
Added on Feb 19 2014
#data, #database-key-features, #export-import-sql-loader-external-tables
5 comments
837 views