Creating non-locking temporary tables
Hi there! I am having an issues with temporary tables that I was curious if anyone else had encountered before.
In our environment, we have slave servers that we are utilizing for the purposes of reporting. On those slave servers, we are creating temporary tables to stage data. If we happen to get a transaction from the master server that affects one of those rows, it is causing a deadlock that is breaking replication.
Is there a safe way to create temporary tables on a slave server that would not break replication should this situation occur?
Thank you!
Subject
Views
Written By
Posted
Creating non-locking temporary tables
1396
October 29, 2016 02:03PM
674
October 30, 2016 05:16PM
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.