Re: DBMS_STATS Syntax

Shouldn't that be

    FOR INDEXES
not

    FOR ALL INDEXES (I haven't checked the manual, though,
so I may be wrong.)

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____UK_______April 22nd
____Denmark__May 21-23rd
____USA_(FL)_May 2nd

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK_(Manchester)_May
____Estonia___June (provisional)
____Australia_June (provisional)
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"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

>

>

>