-
how to analyze LOB index
hi,
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
Many Thanks,
-
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."
-
I have a BLOB column in the table AAA which created the LOB index
INDEX_NAME INDEX_TYPE TABLE_NAME
------------------------------ ---------------------------
SYS_IL0000009959C00003$$ LOB AAA
Just a clarification, the BLOB column which has created a LOB index cannot be analyzed.
(ie)
begin
dbms_stats.gather_index_stats(ownname=> 'AAA', indname=> 'SYS_IL0000009959C00003$$', partname=> NULL);
end;
Many Thanks,
-
I think the only thing you can do is specify at table (lob column) creation where the lob index will live. If you don't have a ton of lob's, I wouldn't even concern myself with it.
Best of luck.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|