Gather Statistics error through Environment Manager but OK through SQL Deve
789544Aug 4 2010 — edited Aug 5 2010When I gather statistics through SQL Developer it is fine.
When I log on through Environment Manager and submit a job to gather statistics the process fails with the following error.
Oracle 10g database.
ORA-29900 operator binding does not exist
ORA-06540 PL/SQL compilation error
ORA-06553 PLS-907 cannot load library unit SYS.XML.SEQUENCEFROMXMLTYPE (referenced by SYS_XMLSEQUENCE)
ORA-06512 at "SYS.DBMS_STATS" line 17964 ORA-06512 at "SYS.DBMS_STATS" line 18410
ORA-06512 at "SYS.DBMS_STATS" line 18607
ORA-06512 at "SYS.DBMS_STATS" line 18566
ORA-06512 at line 3
I have tried scheduling with numerous users (including SYS) and seem to get the same error.
I think maybe there is some incorrect set up somewhere.
I am not really a database person, so I am unsure of where the operator binding is set for DBMS_STATS.
If anyone has any ideas on how to solve this it would be greatly appreciated.
For the moment I will workaround by updating stats manually through SQL Developer
Thanks
Sherriden McDonald