Re: Why isn't my script running?

> Here is the script:

<snip...>
> exec dbms_stats.gather_schema_stats('TEST',ESTIMATE_PERCENT=>30,CASCADE=>TRUE)
<snip>


Why don't you set up a job in the dbms_scheduler instead of running a
shell script?

easier - not environment dependent


Or have I missed something completely obvious?


Paul...


> Still won't fire from cron, but runs as $sh test_schema_stats.sh


If you do it inside the db server, you don't have to worry about
your OS environment or anything else - the reason Oracle
did this in the first place.


Paul...



-- 
linehanp@xxxxxx

Mob: 00 353 86 864 5772
--
http://www.freelists.org/webpage/oracle-l

Other related posts: