Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: freelists and dba_free_space

Re: freelists and dba_free_space

From: Peter Sylvester <not_me_at_not_here.org>
Date: Wed, 15 Feb 2006 16:56:26 -0500
Message-ID: <dt085v$n5v$1@newslocal.mitre.org>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US