Update table under other schema (want to setup a mirror Table)
89842Jan 17 2006 — edited Jan 18 2006I have a table 'myTable' under schemaA, I want to setup a mirror table 'mirrorTable' under schemaB. I write database triggers where 'Update', 'Insert' and 'Delete' on 'myTable' will update the same in 'mirrorTable'.
How do I switch between schema A and B. Or I just put the schema name in front of the table name is OK?
e.g. Update schemaA.myTable set (col1, col2) = (select col1, col2 from schemaB.mirrorTable')
OR there is other better way to setup a mirrortable?
Please help!!!