Hot answers tagged oracle-11g
You can't embed DDL in a stored procedure like this. Either use execute immediate and your DDL statement passed to it as a string, or, better, remove the stored procedure entirely an execute the DDL directly.
All the information regarding statistics gathered with dbms_stats can be found on dba_tab_stats_history. Ref.: http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2103.htm#BGBBBGCC
Only top voted, non community-wiki answers of a minimum length are eligible