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