Data been inserted, but not exist in database
910806Jan 12 2012 — edited Jan 19 2012I have user claimed he had inserted data to database before he printed out the data by executing another job on our application.
I checked the printed data, he really did insert the data he claimed, oddly, I can not find the data in our database.
More surprisingly, one time, my user asked me to check a record for its existence in database when he just inserted a record in his end.
I can query the data out with my toad, but when my user log out application, I query the data again, the data is gone. Why?
(We didn't offer every user an oracle account, our users use system id we named to log in database)
Could SGA size factor cause this happen, Or any other expert who have met this question before? could anyone provide such experince to me?
Or give a guide to detect what might go wrong?