Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SP2-0332: Cannot create spool file

SP2-0332: Cannot create spool file

From: werrt <werrt_at_uio.com>
Date: Mon, 31 Oct 2005 01:42:22 GMT
Message-ID: <2Ee9f.66709$S4.23987@edtnps84>


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:42:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US