Can DBMS_STAT gather statistics on case sensitive schema and object names?
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: