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?
7250
May 04, 2006 06:32PM
4947
May 05, 2006 01:10AM
4860
May 05, 2006 01:17AM
5100
May 05, 2006 02:08AM
5000
May 05, 2006 02:27AM
5361
May 05, 2006 03:16AM
5126
May 05, 2006 03:17AM
4576
May 05, 2006 03:35AM
5342
May 08, 2006 02:13AM
4963
May 08, 2006 08:49PM
5088
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.