CREATE_STAT_TABLE - HowTo?

[maxhugen]

I'd like to create the stats table from the DBMS_STATS package, but I'm doing something wrong...

I tried the following:

CREATE_STAT_TABLE (
'sys',
'stats',
'system');

I thought this would create the stats table, as user 'sys', with the name 'stats', in the 'system' tablespace, but I get:

ORA-00900: invalid SQL statement

I also tried using DBMS_STATS.CREATE_STAT_TABLE ( .... ); but no go.

As I'm going blind reading through all the documentation (which isn't helping unfortunately), would someone kindly point out what I'm doing wrong?

MTIA, Max Hugen

[pando]

SQL> exec DBMS_STATS.CREATE_STAT_TABLE('lsc','dbms_stats_table','users')

PL/SQL procedure successfully completed.

SQL> desc dbms_stats_table
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 STATID                                             VARCHAR2(30)
 TYPE                                               CHAR(1)
 VERSION                                            NUMBER
 FLAGS                                              NUMBER
 C1                                                 VARCHAR2(30)
 C2                                                 VARCHAR2(30)
 C3                                                 VARCHAR2(30)
 C4                                                 VARCHAR2(30)
 C5                                                 VARCHAR2(30)
 N1                                                 NUMBER
 N2                                                 NUMBER
 N3                                                 NUMBER
 N4                                                 NUMBER
 N5                                                 NUMBER
 N6                                                 NUMBER
 N7                                                 NUMBER
 N8                                                 NUMBER
 N9                                                 NUMBER
 N10                                                NUMBER
 N11                                                NUMBER
 N12                                                NUMBER
 D1                                                 DATE
 R1                                                 RAW(32)
 R2                                                 RAW(32)
 CH1                                                VARCHAR2(1000)