*** ACTION NAME:(AUTO_SPACE_ADVISOR_JOB) -- ::58.046
*** MODULE NAME:(DBMS_SCHEDULER) -- ::58.046
*** SERVICE NAME:(SYS$USERS) -- ::58.046
*** SESSION ID:(112.762) -- ::58.046
*** -- ::58.046
ORA-: error on auto execute of job
ORA-: invalid SQL name
SQL> Select * from v$version; BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1. - Prod
PL/SQL Release 10.2.0.1. - Production
CORE 10.2.0.1. Production
TNS for -bit Windows: Version 10.2.0.1. - Production
NLSRTL Version 10.2.0.1. - Production
网上查看说这个是一个bug,禁用掉该JOB
conn "/as sysdba"
execute dbms_scheduler.disable('AUTO_SPACE_ADVISOR_JOB');
参考博客:
http://www.xifenfei.com/2305.html
http://blog.itpub.net/9524377/viewspace-660845/