My Oracle Support Banner

SP2-0310 When Execute Or Spool File Under Root Directory Of Mapped Drive Like "Z:/" (Doc ID 2908129.1)

Last updated on MAY 03, 2024

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:

SP2-0310: unable to open file "Z:\testplus.sql"

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


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

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