Re: Why isn't my script running?
Date: Thu, 26 Feb 2009 06:58:57 +0000
> Here is the script:
> exec dbms_stats.gather_schema_stats('TEST',ESTIMATE_PERCENT=>30,CASCADE=>TRUE)
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?
> 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.
-- linehanp_at_tcd.ie Mob: 00 353 86 864 5772 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 26 2009 - 00:58:57 CST