Re: dbms_stats

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(....)?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)