Platform: Oracle 8.1.7 on Solaris
I'm trying to set up a dbms_job to execute
dbms_stats.gather_schema_stats. I've actually got it working, but am
a bit puzzled by one thing. I found that I had to submit the job
(exec dbms_job.submit) while logged on as the owner of the schema
whose stats were being gathered. If I submitted the job while logged
on as SYSTEM, the job would submit, but its execution would fail. Is
this to be expected, or did I miss something in the docs?
Received on Wed Mar 26 2003 - 17:26:51 CST
