Re: RUN the script(UTL_FILE) as system/manager

From: Hans Forbrich <hforbric_at_yahoo.net>
Date: Wed, 18 Feb 2004 16:12:59 GMT
Message-ID: <faMYb.22738$Ff2.20382@clgrps12>

MATHEW KING wrote:
> Hi Everone,
>
> With regards to UTL_FILE package, when I connect as a system/manager
> and run a script to read the O/S files, it can't run successfully.
> But when I connect as a sysdba ,the script which contains UTL_FILE
> Features , runs successfully .
> Why we can't run the script which contain (utl_file) via connecting
> as a system/manager.What should I do in order to run the script as a
> system/manager or other user.
> I have also run the utlfile.sql script via connecting as
> system/manager.
>
> Thanks
>
> David.

Many (most?) of Oracle's supplied scripts actually have comments at the top which tell how/when they should be run. Worth looking! /Hans Received on Wed Feb 18 2004 - 10:12:59 CST