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:

Symptoms

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.

For Example:
Given Z is mapped to UNC \\path
where script.sql is under Z:\ root and also under Z:\sub-folder

Works:

The following is successful when use UNC or sub-folder or no path in script:

Summary:
Only file under root directory of network mapped drive "Z:/" fails to execute or write via spool.

Changes

 Upgrade to SQL*Plus 21c.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.