got an error when analyzing a lob index using dbms_stats.gather_index_stats.This analyze is shceduled as a job in OEM.
ORA-20000: Unable to analyze INDEX "TABLENAME"."SYS_IL0000009959C00003$$",
insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_STATS", line 8195
ORA-06512: at "SYS.DBMS_STATS", line 8234
07-05-2005, 06:35 PM
I'm guessing that's not an option. Notice what the 9i docs say about analyzing a table with a LOB column .. it's skipped.
"You cannot compute or estimate statistics for the following column types: REFs, varrays, nested tables, LOBs (LOBs are not analyzed, they are skipped), LONGs, or object types. However, if a statistics type is associated with such a column, then user-defined statistics are collected."
07-05-2005, 06:46 PM
I have a BLOB column in the table AAA which created the LOB index