Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: i dont see log when data insert fails for some reason

Re: i dont see log when data insert fails for some reason

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Wed, 28 Feb 2007 15:07:31 -0600
Message-ID: <45e5e287$0$16288$88260bb3@free.teranews.com>


kulkarni.ninad_at_gmail.com wrote:
> Basically, i was attempting to insert a data in one my table while the
> oracle blowed an error saying that cannot insert data in column x
> since the data type for that column is small. After that i altered the
> table made the correct change and but now my question is i dont see
> this error in my logs where i can i get this information in logs or do
> i need to modify my log settings in order see such column errors?
>

This type of error is not entered into the Alert log. So you wont be able to find it there.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com
Received on Wed Feb 28 2007 - 15:07:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US