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 Wed Apr 09 2003 - 13:04:43 CDT
