PLS-00302: component 'AUTO_DEGREE' must be declared

[alberto_il 0]

Olá,Alguém sobe o que é isto ?Quanto tento executar o sql script collectObjectStats.sql, recebo os seguintes erros:LINE/COL ERROR-------------------------------------------------------------------------21/7 PL/SQL: Statement ignored24/30 PLS-00302: component 'AUTO_DEGREE' must be declaredScript linhas 21 a 25:------------------------21 DBMS_STATS.GATHER_TABLE_STATS(22 ownname => '', 23 tabname => tab_rec.TABLE_NAME,24 degree => DBMS_STATS.AUTO_DEGREE,25 cascade => gatheridx);Script Completo:-------------------CREATE OR REPLACE PROCEDURE collect_tab_ind_stats(gatheridx IN boolean DEFAULT TRUE) AUTHID CURRENT_USERAS CURSOR tab_cur IS SELECT table_name FROM user_tables;BEGIN DBMS_OUTPUT.PUT_LINE('Running J2EE statistics gathering...'); FOR tab_rec IN tab_cur LOOP BEGIN IF gatheridx THEN DBMS_OUTPUT.PUT_LINE('Analyzing table ' || tab_rec.TABLE_NAME ||' and referenced indexes.'); ELSE DBMS_OUTPUT.PUT_LINE('Analyzing table ' || tab_rec.TABLE_NAME); END IF; DBMS_STATS.GATHER_TABLE_STATS( ownname => '', tabname => tab_rec.TABLE_NAME, degree => DBMS_STATS.AUTO_DEGREE, cascade => gatheridx); exception when others then dbms_output.put_line('FAILED TO GATHER TABLE STATISTICS.'); END; END LOOP; DBMS_OUTPUT.PUT_LINE('Done.');END collect_tab_ind_stats;/Grato,Alberto

[alphamek 2]

Alberto,Tu está conectado como SYS ou como SYSTEM?Abraços, :B