Re: package SYS.DBMS_STATS

se wrote:
> Hello,
> When I execute the statistic package: SYS.DBMS_STATS, on my database whith
> more 9.000.000 records
>
> My scrip with system/manager
> exec
> dbms_stats.gather_schema_stats(ownname=>'ENAV',estimate_percent=>10,cascade=>TRUE
>
> I have this error message. What can I do?
> BEGIN
> dbms_stats.gather_schema_stats(ownname=>'ENAP',estimate_percent=>10,cascade=>TRUE);
> END;
>
> ERREUR à la ligne 1 :
> ORA-00933: La commande SQL ne se termine pas correctement
> ORA-06512: à "SYS.DBMS_STATS", ligne 9375
> ORA-06512: à "SYS.DBMS_STATS", ligne 9857
> ORA-06512: à "SYS.DBMS_STATS", ligne 10041
> ORA-06512: à "SYS.DBMS_STATS", ligne 10095
> ORA-06512: à "SYS.DBMS_STATS", ligne 10072
> ORA-06512: à ligne 1
>
>
> Thank.
> Se, the frenchie

SQL*Plus: Release 10.1.0.4.0 - Production on Fri Jul 8 08:27:52 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> exec
dbms_stats.gather_schema_stats(ownname=>'PSOUG',estimate_percent=>10,cascade=>TRUE);

PL/SQL procedure successfully completed.

SQL>

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)