From: werrt on
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(a)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;



From: IANAL_VISTA on
"werrt" <werrt(a)uio.com> wrote in news:2Ee9f.66709$S4.23987(a)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?
>
> CREATEUSER.SQL********************
>
> SPOOL log/CREATEUSER.LOG;

More than likely, either you don't have permissions to at the OS level,
or no "log" folder exists under your current directory.
From: tramplai@gmail.com on

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(a)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;

From: HansF on
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 ***