Re: dbms_stats

From: Igor Racic <igor.racicC_at_freesurf.fr_no_C>
Date: Sat, 21 Aug 2004 10:08:12 +0200
Message-ID: <41270269$0$26995$626a14ce@news.free.fr>

Daniel Morgan wrote:
> Wayne March wrote:
>

>> I try to execute dbms_stats.gather_schema_stats (ownname => 'SYSADM'
>>                                                 , degree => 12
>>                                                 , percent_estimate => 30
>>                                                 , cascade => true) ;
>> and I am getting
>> dbms_stats.gather_schema_stats (ownname => 'SYSADM'
>>                                         *
>> ERROR at line 1:
>> ORA-00900: invalid SQL statement
>>
>> Any ideas how do i fix this situation

>
>
> Could it be as easy as:
>
> SQL exec dbms_stats.gagther_schema_stats(....)?
>

Ej, man. It's a newbie!
I suppose it would help him more to give correct syntax instead of "I'm clever" preach (2 errors in oneliner).

begin
dbms_stats.gather_schema_stats( ownname => 'SYSADM'

                                 , degree => 12
                                 , estimate_percent => 30
                                 , cascade => true) ;

end;
/

Igor Received on Sat Aug 21 2004 - 03:08:12 CDT