Ok to write directly to member of merge table?
I have a MERGE table that uses INSERT_METHOD=FIRST to insert into the first table Q. I also have processes that *directly* write into this table Q. We went live with this setup today, and it has been having lots of trouble. The table has become corrupted at least 10 times, causing everything to fail until a REPAIR TABLE Q is performed.
The MERGE table is a (connection-specific) temporary table that gets created/dropped very often, and table Q can get several writes per second coming from several different servers (so truly simultaneous writes are possible).
Am I doing something wrong for which I should accept the blame for getting my table corrupted?
We are on 4.1.18 right now, but upgrading to 4.1.19 tonight. Will this fix the problem?
Thanks,
Nathan
Subject
Views
Written By
Posted
Ok to write directly to member of merge table?
6747
May 04, 2006 06:32PM
4690
May 05, 2006 01:10AM
4626
May 05, 2006 01:17AM
4792
May 05, 2006 02:08AM
4696
May 05, 2006 02:27AM
4796
May 05, 2006 03:16AM
4697
May 05, 2006 03:17AM
4287
May 05, 2006 03:35AM
4619
May 08, 2006 02:13AM
4664
May 08, 2006 08:49PM
4823
May 16, 2006 10:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.