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 MARCH 08, 2017

Applies to:

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


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"

-- Business Impact:

Scripting the extraction of DDL files from the database, but some user objects have "$" in the name and it causes the SPOOL command to fail.  In other cases, it is an application requirement having files including a $ symbol.

-- What is working:

Scripts 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!

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