Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: freelists and dba_free_space
Ben wrote:
> 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.
>
Try using:
cascade=>true
--Peter Received on Wed Feb 15 2006 - 15:56:26 CST