Re: [Replication] Big Joins do not get replicated
Posted by:
James Day
Date: April 24, 2005 04:32PM
You could try doing the INSERT ... SELECT in several pieces. Perhaps using WHERE primary key <10000 then WHERE primary_key >= 10000 and primary_key < 20000 and so on. That can increase reliability if the table you're selecting from is ofen locked, because it will decrease the chance of a ock wait timeout if other operations are using the table. Changing MAX_JOIN_SIZE may be the most convenient solution, though.
Subject
Views
Written By
Posted
3017
April 07, 2005 02:28AM
Re: [Replication] Big Joins do not get replicated
1818
April 24, 2005 04:32PM
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.