CREATE_STAT_TABLE - HowTo?
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
Max Hugen
Hugen Enterprises Pty Ltd
www.hugen.com.au