Hi Experts,
I have small requirement as below,can you people suggest me?
Table A(X schema) Table B(Y schema)
How to get sync between these tables...these tables should have same data and i have already tried triggers but its impacting another process..
so i'm unable to use triggers here.....
And people may say that why can't use single table for both the schemas,but there will be performance issue because there are many jobs will access the tables.
Please let me know if any other solutions are there?
Thanks in advance...!!!