Re: Replication without deletes and drops
Logs make possible to exactly recreate a db before a wrong DELETE or DROP.
It is not possible to log all statements except for DROPs or DELETEs. Even theorically. Try thinking the following case:
INSERT INTO a (id, name) VALUES (1, 'george');
DELETE FROM a WHERE id=1;
INSERT INTO a (id, name) VALUES (1, 'bill');
You can't disable DELETE replication but, if you could, the second INSERT would return an error on the slave and data would be different.
Subject
Views
Written By
Posted
4141
September 24, 2004 10:42AM
2562
October 05, 2004 03:20PM
Re: Replication without deletes and drops
3100
October 12, 2004 07:01AM
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.