> Wolfe Stephen S GS-11 6 MDSS/SGSI wrote:
>
> SQL> @D:\Latest_Reference_Files\run_tpocs_303_scripts.sql
> SP2-0332: Cannot create spool file.
> SP2-0310: unable to open file
> "d:\tpocs_303_scripts\add_columns_and_compile.sql"
> SP2-0310: unable to open file
> "d:\tpocs_303_scripts\i_ads_arc_general_ledger_trig_301.sql"
> SP2-0310: unable to open file
> "d:\tpocs_303_scripts\i_ais_arc_general_ledger_trig_301.sql"
> SP2-0310: unable to open file
> "d:\tpocs_303_scripts\i_aus_arc_general_ledger_trig_301.sql"
> SP2-0310: unable to open file
> "d:\tpocs_303_scripts\i_aus_arc_general_ledger_proc.sql"
> SP2-0310: unable to open file
> "d:\tpocs_303_scripts\i_post_bills_package_spec.sql"
> SP2-0310: unable to open file
> "d:\tpocs_303_scripts\i_post_bills_package_body.sql"
> SP2-0310: unable to open file
> "d:\tpocs_303_scripts\i_adhoc_views_table_data.sql"
> SP2-0310: unable to open file
> "d:\tpocs_303_scripts\ahq_i_interface_load_error_view.sql"
> SP2-0310: unable to open file
> "d:\tpocs_303_scripts\ahq_i_encounter_ndc_view_301.sql"
> SP2-0310: unable to open file
> "d:\tpocs_303_scripts\ahq_i_permanent_bill_ndc_view_301.sql"
> SP2-0310: unable to open file
> "d:\tpocs_303_scripts\ahq_i_general_ledger_301_view.sql"
> not spooling currently
>
> How do I T/S the above problem. The MHS support center said the
> script (which modifies the attributes of one database on a 9i
> server running under Win2K) should take only 20 minutes to run.
>
> We are mainly a MSSQL2K shop, but recently we have gained two new
> medical applications that uses 9i as the back end. I have a request
> in for Oracle DBA training on site for myself and my other two
> SQL DBAs, but the facility has yet to fund the request -- it is
> approved,
> not funded -- isn't the government wonderful ... <ggg>
>
> Any help would be greatly appreciated, I suspect this is a simple
> problem.
>
> v/r
>
> Stephen S. Wolfe, GS-11, DAFC
> Data Services Manager
> stephen.wolfe_at_macdill.af.mil
> (813) 827-9974 DSN 651-9974
Stephen,
Indeed likely to be simple. You have two distinct problems here :
- Cannot create spool file
It's simply that you cannot write in the current directory. 'not
spooling currently' derives from this and is generated by a 'spool off'
command.
- Failure to read the various SQLfiles. Either the directory doesn't
exist, or the file do not exist, in which case your installation was
probably incomplete. Or you are not allowed to read it. In which case it
may be the same as 1) - perhaps you are simply not logged in as the
suitable user.
Or you have shifted files around after the installation,in which case
reinstalling from scratch is probably the safest thing to do.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: sfaroult_at_oriole.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sat May 17 2003 - 14:51:51 CDT
