Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-20000 statistics collection in 11.2.0.3 Enterprise edition

946401Feb 10 2014 — edited Feb 11 2014

Hi,

on linux as sysdba

Getting below error

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Beta

SQL> exec dbms_stats.gather_schema_stats(ownname=>'USER1',estimate_percent =>10);

BEGIN dbms_stats.gather_schema_stats(ownname => 'USER1',estimate_percent =>10); END;

*

ERROR at line 1:

ORA-20000: Statistics collection failed for 138 objects in schema

ORA-06512: at "SYS.DBMS_STATS", line 24961

ORA-06512: at "SYS.DBMS_STATS", line 24899

Could you please help out.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2014
Added on Feb 10 2014
#general-database-discussions
8 comments
4,133 views