DBMS_JOB.SUBMIT has bunch of output/input parameters - one of the input parameters is WHAT, which defines what exactly the job has to do. In your case, WHAT parameter is 'DBMS_UTILITY.ANALYZE_SCHEMA(''TEST'',''COMPUTE'');'.
So, can you succesfully run
BEGIN
DBMS_UTILITY.ANALYZE_SCHEMA('TEST','COMPUTE');
END;
/
as DB_ADMIN user?




Reply With Quote