SP2-0310 When Execute Or Spool File Under Root Directory Of Mapped Drive Like "Z:/"
(Doc ID 2908129.1)
Last updated on NOVEMBER 14, 2022
Applies to:SQL*Plus - Version 21.1 and later
Information in this document applies to any platform.
SQL*Plus 21c fails to open file when it resides under root directory of a network mapped drive. It fails with the following error:
However, it is able to open using SQL*Plus 19c.
This happens only with network mapped drive root directory. SQL*Plus 21c can open file if using UNC path, or if file is in a sub-folder of a network mapped drive.
The same holds true for SPOOL output file.
Given Z is mapped to UNC \\path
where script.sql is under Z:\ root and also under Z:\sub-folder
The following is successful when use UNC or sub-folder or no path in script:
Only file under root directory of network mapped drive "Z:/" fails to execute or write via spool.
Upgrade to SQL*Plus 21c.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document