Re: Values insys.hist

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Wed, 10 Sep 2003 07:42:59 -0700
Message-ID: <1063204962.680891@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

DATA_LENGTH DATA_PRECISION
----------- --------------
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)

Received on Wed Sep 10 2003 - 09:42:59 CDT

Re: Values insys.hist_head$ table.