Hello all,
I have an oracle 9i database -> 9.2.0.8.0.
On this database we have a table that has close to 40,00000 records.
When we are doing an insert to this table as :
insert into <Table1> select * from <Table2> where date> sysdate - 1/24;
commit;
it says 70 records inserted.
When I check for the destination table these 70 records have not come in, I once again ran the above query followed by the commit statement.
and then rechecked the records but still they were not available.
I disconnected the session and connected back again and found 140 records, I deleted these 140 records and then ran the above query again and this time it got reflected, I was
able to see the 70 records in the destination table.
I am not able to find out what might be this strange behavior.
Can anyone please put some light into this issue or give some suggestions why this might have occurred.
if you would require further information please revert back to me.
Thanks and Regards
CK