Re: ORA-01401: inserted value too large for column

Tony,

v$active_session_history.
as perscribed by others here on the list, set statistics_level='BASIC' and these will go away. (thanks, Niall).

this was for 10.1.0.3 on win32 - but since you did not include the database version and OS ... I'm just guessing. (hint)

Paul

On Thu, 24 Feb 2005 14:30:18 +0100, Tony.Adolph_at_o2.com <Tony.Adolph_at_o2.com> wrote:
> Hi all,
> A developer here is trying to find the source of the error "ORA-01401:
> inserted value too large for column". He want to know which table /
> column(s) are causing the problem.
>
> The error is not logged in the alert log.
>
> I set sql_trace = true and had him repeate his tests. Although we got
> bucket loads of trace files in both user_dump_dest and
> backfround_dump_dest we did not get any trace files or errors relating to
> ORA-01401. I tried to grep for just the 1401 string, still nothing.
>
> How can find the culprit here folks?
>
> Cheers
> Tony
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.
--
http://www.freelists.org/webpage/oracle-l