Return
-
Title
ORA-20000: Gathering statistics for an index on temporary table is not supported -
Description
An analysis job aborts with ORA-20000: Gathering statistics for an index on temporary table is not supported
-
Cause
The analysis job has attempted to analyze an index on a temporary table.
-
Resolution
WORKAROUND:
Adjust the selected object list to exclude indexes. Indexes will be automatically added for any tables that are analyzed, so indexes do not need to be included in the selected object list.
This can be accomplished with syntax such as;
...and object.object_type not like 'INDEX%'
STATUS:
Waiting for fix in a future release Live Reorg. -
Defect ID
CR0221552