Guessing, are you submitting the failing jobs as another user? If so, check
on the execute privilage for DBMS_STATS to the user. You may have to grant
this.

Thanks!
amar

-----Original Message-----
From: Sood Ankit (GE Consumer Finance consultant)
[mailto:oracledba-ezmlmshield-x2086189.[Email address protected]
Sent: 31 May 2005 11:37
To: LazyDBA Discussion
Subject: analyzed schema


Dear all,
I am using the Oracle procedure to analyze the schema.When I am maually
running the procedure it is running fine from the system user. The same
procedure running through Oracle jobs giving me error as insufficient
privileage.The same procedure is running fine from Oracle jobs as sys user.
Please provide the input.



Regards
Ankit Sood
GE Consumer Finance
Japan
Phone: 042-330-8734
Mobile No: 09098429482




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page