chris b wrote:
> 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
It isn't telling you that DBMS_STATS doesn't exist ... it is telling
you that the index doesn't exist or you have no privileges to analyze
it.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Jan 17 2006 - 15:45:59 CST
