Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SP2-0332: Cannot create spool file
werrt wrote:
> 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?
>
> SK.
>
> CREATEMOVIES.SQL*****************
> SET ECHO OFF
> UNDEF DBNAME
> PROMPT WHAT IS THE DATABASE OR NETWORK NAME? (SUCH AS: OLTP)
> ACCEPT DBNAME
> PROMPT CONNECTING TO SYSTEM NOW.
> CONNECT scott/tiger_at_orcl AS SYSDBA
> @c:\sql\CREATEUSER.SQL
>
>
> CREATEUSER.SQL********************
>
> SPOOL log/CREATEUSER.LOG;
> DROP USER MOVIES CASCADE;
> CREATE USER MOVIES IDENTIFIED BY MOVIES
> DEFAULT TABLESPACE USERS
> TEMPORARY TABLESPACE TEMP
> QUOTA UNLIMITED ON USERS
> QUOTA UNLIMITED ON TEMP;
> GRANT CONNECT,RESOURCE TO MOVIES;
> GRANT UNLIMITED TABLESPACE TO MOVIES;
> SPOOL OFF;
Received on Sun Oct 30 2005 - 19:50:13 CST