Getting ORA-14452 when trying to gather stats

  • From: "Sandra Becker" <sbecker6925@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 16 Nov 2006 14:57:19 -0700

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

Other related posts: