|
-
Mate,
thanks all, this is what I have :
I did have the proper grant to the user who run the job to SYS.DBMS_UTILITY and when I execute the below it ran fine:
BEGIN
SYS.DBMS_UTILITY.ANALYZE_SCHEMA('TEST','COMPUTE');
END;
but when I put it in the DBMS_JOB to run, it failed and I log into the log UNSUFFICIENT PRIVILEGE on execute SYS.DBMS_UTILITY.
I am getting closer but I couldn't figure it out what's going on.
any ideas???
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|