Re: dbms_stats

(1) Need more information. Versions (server and client) and anything else you could supply that might be helpful. (2) Is the Procedural Option installed in the database? Submit

    select * from v$version;

and see if PL/SQL shows up. You get this error if you don't have that. (Metalink note).

(3) Are you running this as a SQLPLUS line (execute) or as a PL/SQL block? Coz if it's just a SQLPLUS command and it's more than one line then you need to append the hyphen '-' (continuation character). Although that would give another error message. All speculation so please copy and paste the exact thing you ran and messages you got.

(4) And lastly, I think PERCENT_ESTIMATE parameter name should be ESTIMATE_PERCENT. (at least in 9i). (That would also give another error message).

Cheers.

wmarch_at_cfl.rr.com (Wayne March) wrote in message news:<69e9fe8c.0408191045.5c13cfb0_at_posting.google.com>...
> 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
Received on Thu Aug 19 2004 - 20:58:54 CDT