Joined: 3-March 17
Member No.: 51,815
In oracle database I have a table say xyz, and I want to have a replica of that table as xyz_replica in same database and same schema. so that when ever there is DML operation such as delete,insert,update statements runs on the xyz table is has to replicate in xyz_replica table.
I thought of using triggers but not sure how to write the query when doing the update or delete as I am unsure how many rows will get changed in xyz table.