SP2-0606: Cannot create SPOOL file

I got ” SP2-0606: Cannot create SPOOL file”  error in Oracle database.

SP2-0606: Cannot create SPOOL file

Details of error are as follows.

SP2-0606 Cannot create file file_name

Cause: The STORE command was unable to create the specified file. 
There may be insufficient disk space, too many open files, or read-only protection on the output directory.

Action: Check that there is sufficient disk space and that the protection on the directory allows file creation.

Cannot create SPOOL file

This SP2-0606 error is related with the STORE command was unable to create the specified file.

There may be insufficient disk space, too many open files, or read-only protection on the output directory.

To solve this error, Check that there is sufficient disk space and that the protection on the directory allows file creation.

On Windows, spooling SQL*Plus output to a file in the root folder results in a SP2-0606 error

Modern Windows do not allow files to be created in some folders (e.g. the root folder) by default.
Be sure to specify a folder where permissions allow a file to be created.
Check and allow write permissions for authenticated users  on Operating system.

Do you want to learn Oracle Database for Beginners, then read the following articles.