Error SP2-0332 While Creating Spool File Name Using a Variable Followed by Other Characters

(Doc ID 566443.1)

Last updated on JULY 03, 2017

Applies to:

SQL*Plus - Version 10.2.0.3 and later
Linux x86-64
This applies to Linux/Unix Platforms.



Symptoms

While spooling script output to a file from SQL*Plus,  the following error is returned:

SP2-0332 : Cannot create spool file.


Example script: 

Sql> spool $ORACLE_SID_backup_script.sql
Sql> Select 'This is backup script' from dual;
Sql> spool off 

Changes

The script works on Windows; however, the script fails with SP2-0332 on Linux and other Unix operating systems (OS).

Cause

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 hundreds of Community platforms