Re: Values insys.hist_head$ table.

Hi!

Which version are you on? 9.2.0.3+?
You could try to drop statistics using "analyze table delete statistics" on the problematic table and then reanalyze. Join obj# in hist_head$ to object_id in dba_tables to find out which table is causing the problem.

Tanel.

  "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:1063204962.680891_at_yasure...   Dotan S. wrote:

Hi,
Found that the SAMPLE_SIZE (NUMBER) column in that table have value of 1E126.
This gives me numeric overflow error since this number is greater than the NUMBER datatype .
What can be done in order to fix this problem.

Thanks Dotan.
  Connected to:
  Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production   With the Partitioning, OLAP and Oracle Data Mining options   JServer Release 9.2.0.4.0 - Production

  SQL> select data_type, data_length, data_precision     2 from dba_tab_columns
    3 where table_name = 'HIST_HEAD$'
    4 and column_name = 'SAMPLE_SIZE';

  DATA_TYPE

• -------------- NUMBER 22

  Verify as above and if true ... go to metalink and find out how to replace the corrupt table.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)