Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DBMS_STATS Syntax

DBMS_STATS Syntax

From: Buck Turgidson <jc_va_at_hotmail.com>
Date: Wed, 09 Apr 2003 18:04:43 GMT
Message-ID: <6ee34f9c3f89216988faf5bdc39fc713@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 Wed Apr 09 2003 - 13:04:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US