From: werrt on 30 Oct 2005 20:42 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 30 Oct 2005 20:49 "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 30 Oct 2005 20:50 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 31 Oct 2005 00:06 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 ***
|
Pages: 1 Prev: Adjust AWE_WINDOW_MEMORY value Next: RAC internals - GLOBAL ENQUEUE SERVICES DEADLOCK DETECTED |