My Oracle Support Banner

Filename With Special Characters like "$" Generates SP2-332 Spooling It Or SP2-310 "Unable To Open File" (Doc ID 761384.1)

Last updated on OCTOBER 26, 2023

Applies to:

SQL*Plus - Version to [Release Oracle10g]
Information in this document applies to any platform.Symptoms

SQL*Plus 10g rel2 or 11g in Unix/Linux displays an error trying to create or read a file that includes a special character like the dollar sign in the name, ie, test$.lst

-- Steps To Reproduce:

SQL> spool test$.lst
SP2-0332: Cannot create spool file.


SQL>start /tmp/test$.lst
SP2-0310: unable to open file "/tmp/test$.lst"

-- What is working:

Scripts with similar names work on MS Windows platform.


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.