gather stats ora-20000

From: chris b <chris.brown_at_providenthims.co.uk>
Date: 17 Jan 2006 04:01:41 -0800
Message-ID: <1137499301.429134.221280@f14g2000cwb.googlegroups.com>

I've been trying to execute code ( logged on as user LIVE ) to gather system stats & get the following

BEGIN
*
ERROR at line 1:
ORA-20000: Unable to analyze INDEX "LIVE"."DSX_CODA_C_LINES_DT_IDX_1", insufficient privileges or does not exist

ORA-06512: at "SYS.DBMS_STATS", line 9375
ORA-06512: at "SYS.DBMS_STATS", line 9389
ORA-06512: at line 2

I've granted gather_system_stats & analyze any to user ...any ideas?

regards
Chris B

PS The object does exist

PS I've included code below
BEGIN

DBMS_STATS.GATHER_TABLE_STATS ( ownname     => 'LIVE',
tabname     => 'DSX_CODA_CANCEL_LINES',
method_opt  => 'FOR ALL INDEXED COLUMNS SIZE 150',
CASCADE	    => TRUE,

granularity => 'PARTITION');
END; Received on Tue Jan 17 2006 - 06:01:41 CST