schema

Schema replication using oracle goldengate

In this tutorial, we will explain how to do schema replication in goldengate. Schema replication means, replicating all the tables of a schema.   1. add supplemental for all tables of a schema [ ...

How to create synonym for a schema

 Usually we create synonym for table. But can we really create synonym for a schema?   Yes, there is an undocumented parameter  _enable_schema_synonyms oracle which enables this feature. Check the ...