after insert commit completed but I cannot see data.

[Printaporn_1]

I use following insert statement:
Insert Into
failure(SN,FailDate,FailCode,Ulocation,PN,Station,Test,SymptomCode,Series,TTF,Te
mp,Volt,FREQ,ERROR_Msg,FailComment,Source,Fixed,Rep_Date,So)
values('CAT0711023Y',sysdate ,'613','Q5','','1350','','',1
,'1','0','0','0','368','','','R',sysDate ,'')
but after select I found no data
SQL> Insert Into
failure(SN,FailDate,FailCode,Ulocation,PN,Station,Test,SymptomC
ode,Series,TTF,Temp,Volt,FREQ,ERROR_Msg,FailComment,Source,Fixed,Rep_Date,So)
va
lues('CAT0711023Y',sysdate ,'613','Q5','','1350','','',1
,'1','0','0','0','368',
'','','R',sysDate ,'');
1 row created.
SQL> commit;
Commit complete.
SQL> select sn from failure where sn = 'CAT0711023Y';
no rows selected
(some of insert was truncate here )
---------------------
I try troubleshooting what I found is:
1. rebuild all indexes , analyze table compute statistics , nothing corrupted.
2. if remove insert column "fixed" it will be able to insert.
( I mean after commit complete I can see data for those sn).
3. rename table failure to failure_a it will be able to insert.
4. if rename failure_a back to failure again it will not be able to see data
after insert.
5. no constraint related to failure table.
6. test with other sn got same result as above.
---------------------
I test this same query with another instance with same structure in this same
machine , it work fine.
--------------------
What wrong with my failure table.
thanks in advance,

[Wodisch]

Hi,

do you have any "stored procedure" working upon "insert", and hence *doing* something with/to your data row?

FWIW,
Wodisch

[Printaporn_1]

Hi Wodisch,
thanks for fast response but
I have no store procedure.

[Yogeeraj_1]

hello,

could be a trigger.

select object_name, object_type
from user_objects;

this will show you all objects own by the owner of the objects.

post the output.

Other troubleshooting options will be to use SQLTRACE and TKPROF.

Regards
Yogeeraj

[Steven E. Protter]

How about rollback segments? Is the database busy, could there be competition wiith other users.

metalink did provide a dozen hits none of which meant anything to me.

SEP

[Printaporn_1]

Thanks Yogeeraj abd Steven.
I still doesn't get any clue from trigger/user_objects or rollback.
I just have simple structure database. no resource contention.
I cannot found similar problem in metalink.
Anyway I open a TAR but no response from Oracle for 48 Hrs.
I will update again if problem can be resolved.

[Yogeeraj_1]

hi,

try the SQLTRACE option.

trace your sessions and you will get the solution.

if you need further help, let us know.

best regards
yogeeraj

[Printaporn_1]

Ohhhhh ! I just realize that I post all my screen capture.
WHo know how can I delete my previous post ! it expost my password !!!
SO Stupid I am.

[Printaporn_1]

Hi,
Thanks for help now my problem is solved by re-start database.

same insert statement work !
-----------

SQL> Insert Into failure(SN,FailDate,FailCode,Ulocation,PN,Station,Test,SymptomC
ode,Series,TTF,Temp,Volt,FREQ,ERROR_Msg,FailComment,Source,Fixed,Rep_Date,So) va
lues('CAT0711023Y',sysdate ,'613','Q5','','1350','','',1 ,'1','0','0','0','368',
'','','R',sysdate ,'');

1 row created.

SQL> commit
2 ;

Commit complete.

SQL> select sn from failure where sn = 'CAT0711023Y';

SN
-------------------------
CAT0711023Y

------------------
This is strange , will see what Oracle will response.
But now my big problem is I post my db password ;-(