DBMAINT CAUAJM_E_60015 Failed

Document ID : KB000019753
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

DBMAINT generate the following error:
CAUAJM_E_60015 Failed to retrieve space usage of ujo_afm. Verify the ujoadmin
account has select privileges on ALL_TABLES.
dbstatistics: Unable to run dbspace
...

Solution:

This is a privileges issue, the following queries should solve the problem


 	sqlplus sys/<passwd>@<ORACLE_SID> as sysdba
 	grant ANALYZE ANY to UJOADMIN;
 	grant SELECT ON DBA_TABLES to UJOADMIN;
 	GRANT ujoadmin TO aedbadmin;

Ensure ujoadmin account has select privileges on ALL_TABLES.