SQL Performance (MOSC)

MOSC Banner

Can DBMS_STAT gather statistics on case sensitive schema and object names?

edited May 23, 2013 5:45AM in SQL Performance (MOSC) 4 commentsAnswered
Oracle documentation seemingly doesn't indicate how case sensitive names can be passed into package DBMS_STAT.  This regards an 11gR2 database:

SQL> select * from v$version where rownum=1 ;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

This contrived example reflects production errors while gathering stats on case sensitive schema and object names:

Double quotations result in a syntax error:

SQL> exec dbms_stats.gather_table_stats(ownname=>"Timothy",tabname=>"MyTable",partname=>NULL,estimate_percent=>100,degree=>4) ;
BEGIN dbms_stats.gather_table_stats(ownname=>"Timothy",tabname=>"MyTable",partname=>NULL,estimate_percent=>100,degree=>4) ; END;

                                              *
ERROR at line 1:
ORA-06550: line 1, column 47:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center