SQL Developer and UNC paths
23525May 17 2010 — edited May 28 2010SQL Developer doesn’t seem to understand file path’s using UNC server names which means you have to map a local drive for every shared folder you need to access. Pretty painful.
Appears to be very limited capability for setting the format of exported data. Since we utilize these tools heavily for customer data dumps this is the biggest issue. For example an export of date field to excel comes out like this: 02-MAY-10 12.00.00.000000000 AM. Has anyone figured out how to change this?
If you edit the default path for export and place a UNC address the system does not recognize the UNC \\server\location you have to MAP the network drive to export your result set.
I corrected the data output by modifying the NSL feature under preferences\database. Now the only issue is being able to export to various network resources using UNC pathing instead of mapping to each file share on particular network resources.
This of course is useing Developer version 2.1.1.64
Edited by: kovama on May 17, 2010 9:58 AM