Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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)Received on Fri Jul 08 2005 - 10:29:16 CDT