Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_DATAPUMP.ADD_FILE and network drives
On 14 Feb 2006 14:56:34 -0800, "Ryan" <rwagner_at_iconect.com> wrote:
>How do you specifiy that you want a log file or dump file to be written
>to a path that is a mapped drive to a location on another computer?
>
>In other words, I want to be able to specify
>
>"CREATE DIRECTORY MY_DIR AS 'Y:\'" // where "Y:\" is is mapped to
>another drive on another machine through windows explorer
>
>DBMS_DATAPUMP.ADD_FILE (..., FILENAME => 'my dump file.dmp', DIRECTORY
>=> 'MY_DIR', ...);
>
>or
>
>DBMS_DATAPUMP.ADD_FILE (...,FILENAME => 'MY_LOG_FILE.TXT', DIRECTORY =>
>'MY_DIR', ...);
>
>It will work if I substitute Y:\ for the actual network path ex
>"\\computer_name\dir1\" but will not work with the network directory
>"Y:\"
>
>Thanks.
Oracle has never supported drive letters, only UNC. And the problem wouldn't occur if you set a mapping from your client to your server. In your approach the probably slower network share is going to be a potential bottleneck.
-- Sybrand Bakker, Senior Oracle DBAReceived on Wed Feb 15 2006 - 13:13:15 CST