Re: freelists and dba_free_space

This still comes back with an error.

SQL> exec dbms_stats.gather_table_stats (ownname=>'CRPDTA', tabname=>'F0911', cascade=>'Y')
BEGIN dbms_stats.gather_table_stats (ownname=>'CRPDTA', tabname=>'F0911', cascade=>'Y'); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GATHER_TABLE_STATS'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

It runs fine if I don't try to pass the cascade option.

SQL> exec dbms_stats.gather_table_stats ('CRPDTA', 'F0911')  

PL/SQL procedure successfully completed. Received on Wed Feb 15 2006 - 15:35:29 CST