Re: SP2-0332: Cannot create spool file

On Mon, 31 Oct 2005 01:42:22 +0000, werrt amused us by writing:

> I am trying to run the following script CreateMovies.sql from
> sql plus.
>
>
> SP2-0332: Cannot create spool file.
> DROP USER MOVIES CASCADE
> *
>
> I am getting the above error and no clues what
> it means.
>
> any has clue?
>

Oracle's online documentation site has a wonderful facility - tell it the Oracle error and it will tell you what it means, the most likely cause(s) and the most probably solution(s).

The docco is available at http://docs.oracle.com - you don't tell us what version of Oracle or SQL*Plus so I can't get you closer to the right final page, but go to that site, choose your version and 'View Library'

Copying that for you - this time ...

"
SP2-0332 Cannot create spool file

    Cause: Possible causes:

• Insufficient privileges to create a file.
• A system error made it impossible to create a file.

    Action: Take the following actions:

• Change privileges to allow creation of the file.
• Consult the operating system documentation or contact the System Administrator. "

... and that means you basically are not allowed to create a file in that directory. Could be permissions, file system (disk) full, etc. Try doing a 'host pwd' after your connect to find out what directory you are using.

By the way - scott/tiger should not be a SYSDBA user, creating users should not be done as SYSDBA (just standard DBA) and scott's password should never be set to tiger any more. Hope this is not a production system.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting guarantees I will not respond further ***