Originally posted by mike2000
ORA-20000: You have insufficient privileges for an object in this schema.
That's exactly the error I was asking you about in one of my previous posts in this thread! This error (ORA-20000) is not oracle "generic" error message, it is user defined message, raised by the user defined exception. This errror message is defined inside DBMS_UTILITY.ANALYZE_SCHEMA procedure.

What this realy means is that you have all the needed privileges to run DBMS_JOB and DBMS_UTILITY, but you don't have enough privileges to analyze all the tables in that schema through PL/SQL API. You need to do the following:

GRANT ANALYZE ALL TO db_admin;

and you'll be fine.

BTW, I doubt taht your user DB_ADMIN can successuly run the PL/SQL block I was asking you to run:

BEGIN
DBMS_UTILITY.ANALYZE_SCHEMA('TEST','COMPUTE');
END;
/

It should raise the same ORA-20000 error.