dbms_stats.gather_schema_stats fails
When I execute dbms_stats.gather_schema_stats(ownname =>{owner}, options=> "GATHER_AUTO');
for one owner in the database, I get the error:
ORA-20000: Statistics connection failed or 2 objects in the schema
ORA-06512: at "SYS.DBMS_STATS", line 25535
ORA-06512: at "SYS.DBMS_STATS", line 25472
ORA-06512: at line 2
ok, so that is the error. Which two objects failed? How do I determine what they are? I suspect that some of the stats are locked, but I am not sure which ones they might be...
TIA!
1