error gathering statistics on less than 100 %

Hi,
I found a curious problem on 9.2 when trying to get less than 100% on a table

SQL> EXEC  DBMS_STATS.GATHER_TABLE_STATS( ownname=>'ADM', TABNAME=>'DEFTRANSAC_M
E', ESTIMATE_PERCENT=>50, CASCADE=>TRUE,METHOD_OPT=>'FOR ALL COLUMNS SIZE SKEWON
LY');
BEGIN DBMS_STATS.GATHER_TABLE_STATS( ownname=>'ADM', TABNAME=>'DEFTRANSAC_ME', E
STIMATE_PERCENT=>50, CASCADE=>TRUE,METHOD_OPT=>'FOR ALL COLUMNS SIZE SKEWONLY');
 END;

*
ERROR en lÝnea 1:
ORA-00904: : identificador no vßlido
ORA-06512: en "SYS.DBMS_STATS", lÝnea 9136
ORA-06512: en "SYS.DBMS_STATS", lÝnea 9150
ORA-06512: en lÝnea 1


SQL> EXEC  DBMS_STATS.GATHER_TABLE_STATS( ownname=>'ADM', TABNAME=>'DEFTRANSAC_M
E', ESTIMATE_PERCENT=>1, CASCADE=>TRUE,METHOD_OPT=>'FOR ALL COLUMNS SIZE SKEWONL
Y');
BEGIN DBMS_STATS.GATHER_TABLE_STATS( ownname=>'ADM', TABNAME=>'DEFTRANSAC_ME', E
STIMATE_PERCENT=>1, CASCADE=>TRUE,METHOD_OPT=>'FOR ALL COLUMNS SIZE SKEWONLY');
END;

*
ERROR en lÝnea 1:
ORA-00904: : identificador no vßlido
ORA-06512: en "SYS.DBMS_STATS", lÝnea 9136
ORA-06512: en "SYS.DBMS_STATS", lÝnea 9150
ORA-06512: en lÝnea 1

But when I get 100% I don't get that problem.

SQL> EXEC  DBMS_STATS.GATHER_TABLE_STATS( ownname=>'ADM', TABNAME=>'DEFTRANSAC_M
E', ESTIMATE_PERCENT=>100, CASCADE=>TRUE,METHOD_OPT=>'FOR ALL COLUMNS SIZE SKEWO
NLY');

Procedimiento PL/SQL terminado correctamente.


Trying with other tables I don't get that problem.

SQL> EXEC  DBMS_STATS.GATHER_TABLE_STATS( ownname=>'ADM', TABNAME=>'CUENTAS_ME',
 ESTIMATE_PERCENT=>50, CASCADE=>TRUE,METHOD_OPT=>'FOR ALL COLUMNS SIZE SKEWONLY'
);

Procedimiento PL/SQL terminado correctamente.

SQL>
--
http://www.freelists.org/webpage/oracle-l


Other related posts: