Re: package SYS.DBMS_STATS

"se" <s.ciavaldini_at_free.fr> a écrit dans le message de news:42ce7065$0$25021$8fcfb975_at_news.wanadoo.fr...
| 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
|
|
|

Try
alter session set nls_numeric_characters='.,'; before executing dbms_stats.
This one does not like not having "standard" numeric characters.

Regards
Michel Cadot Received on Sat Jul 09 2005 - 01:49:35 CDT