I recently upgrade to 9.2.0.8 and moved from 32-bit to 64-bit on Linux RHEL4. I was testing all my scripts to make sure everything still worked as expected. Everything seemed to be working well until I tried to gather stats on my primary application schema. Following is my code and errors. I would appreciate any insight as to where my problem might be. I have opened an SR with Oracle, but they haven't responded yet. execute dbms_stats.gather_schema_stats(ownname=>'MONITOR',- BLOCK_SAMPLE=>false,- METHOD_OPT=>'FOR ALL INDEXED COLUMNS',- CASCADE=>TRUE,- ESTIMATE_PERCENT=>20) ; BEGIN dbms_stats.gather_schema_stats(ownname=>'MONITOR', BLOCK_SAMPLE=>false, METHOD_OPT=>'FOR ALL INDEXED COLUMNS', CASCADE=>TRUE, ESTIMATE_PERCENT=>20) ; END; * ERROR at line 1: ORA-14452: attempt to create, alter or drop an index on temporary table already in use ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 284 ORA-06512: at "SYS.DBMS_STATS", line 10265 ORA-14452: attempt to create, alter or drop an index on temporary table already in use ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 284 ORA-06512: at "SYS.DBMS_STATS", line 6670 ORA-06512: at "SYS.DBMS_STATS", line 6696 ORA-25153: Temporary Tablespace is Empty ORA-06512: at "SYS.DBMS_STATS", line 10502 ORA-06512: at "SYS.DBMS_STATS", line 10996 ORA-06512: at "SYS.DBMS_STATS", line 11183 ORA-06512: at "SYS.DBMS_STATS", line 11237 ORA-06512: at "SYS.DBMS_STATS", line 11214 ORA-06512: at line 1 Elapsed: 00:00:00.16 Sandy