Your script works fine in my 9.2 db. I don't have an 817 db to gather
spurious stats on unfortunately.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Buck Turgidson" <jc_va_at_hotmail.com> wrote in message
news:6ee34f9c3f89216988faf5bdc39fc713_at_news.teranews.com...
> Trying to gather stats for my schema, and am getting an error in 8.1.7.
Can
> someone spot my error?
>
> 13:39:35 SQL>
> 13:39:36 SQL> BEGIN
> 13:39:50 2 dbms_stats.gather_schema_stats(
> 13:39:50 3 user
> 13:39:50 4 ,estimate_percent => 30
> 13:39:50 5 ,block_sample => FALSE
> 13:39:50 6 ,method_opt => 'FOR TABLE FOR ALL INDEXES FOR ALL
> INDEXED COLUMNS SIZE 30'
> 13:39:50 7 ,degree => NULL
> 13:39:50 8 ,granularity => 'DEFAULT'
> 13:39:50 9 ,cascade => FALSE
> 13:39:50 10 );
> 13:39:50 11 END;
> 13:39:50 12 /
> BEGIN
> *
> ERROR at line 1:
> ORA-01490: invalid ANALYZE command
> ORA-06512: at "SYS.DBMS_DDL", line 179
> ORA-06512: at "SYS.DBMS_STATS", line 4467
> ORA-06510: PL/SQL: unhandled user-defined exception
> ORA-06512: at "SYS.DBMS_STATS", line 4610
> ORA-06512: at "SYS.DBMS_STATS", line 4720
> ORA-06512: at "SYS.DBMS_STATS", line 4702
> ORA-06512: at line 2
>
>
>
Received on Thu Apr 10 2003 - 03:28:27 CDT
