Re: Temporal tables and slave replication
I'm also having the problem with the insert statement. I did some tests, and found that the replicate-wild-ignore-table= option doesn't seem to work for the table specified in the SELECT. So, for example:
INSERT INTO myReport(
....
)
SELECT
....
FROM
norep_myTemp;
replicate-wild-ignore-table=myschema.norep_% doesn't prevent this statement from being executed. Is this correct? It is causing problems in our system. Do we need to prefix our permanent table (myReport) with no_rep?
Subject
Views
Written By
Posted
2044
July 16, 2012 05:46AM
893
July 16, 2012 08:10AM
995
July 16, 2012 09:47AM
1027
July 16, 2012 10:26AM
908
July 16, 2012 10:51AM
1005
July 16, 2012 11:30AM
1042
July 16, 2012 11:02AM
917
July 16, 2012 10:35AM
899
July 16, 2012 10:52AM
1004
July 16, 2012 11:05AM
913
July 16, 2012 11:45AM
Re: Temporal tables and slave replication
972
July 16, 2012 01:47PM
901
July 16, 2012 03:17PM
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.