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@xxxxxx <Tony.Adolph@xxxxxx> 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 > > -- > //www.freelists.org/webpage/oracle-l > -- #/etc/init.d/init.cssd stop # f=ma, divide by 1, convert to moles. -- //www.freelists.org/webpage/oracle-l