Check Owner Names
As described in Restrictions and Table Requirements for Classic Replication Schemes and Owner of the Classic Replication Scheme and Replicated Objects in the Oracle TimesTen In-Memory Database Replication Guide, the owner names of your replication scheme and your replicated tables must be consistent across all participating databases. This indicates that the replication scheme owner must match in all databases and each table must be owned by the same user in each database.
Check Replication Owner
Check the owner name assigned to your replication scheme by calling the ttIsql repschemes command or by listing the contents of the TTREP.REPLICATIONS table.
This example shows that the replication scheme name, REPSCHEME, has a consistent owner name (REPL) in the databases on both SYSTEM1 and SYSTEM2.
On SYSTEM1:
> ttIsql masterDSN Command> select * from ttrep.replications; < REPSCHEME , REPL , C, 0, 0, -1 > 1 row found.
On SYSTEM2:
> ttIsql -connStr "dsn=subscriberDSN" Command> select * from ttrep.replications; < REPSCHEME , REPL , C, 0, 0, -1 > 1 row found.
This example shows inconsistent owner names for the replication scheme. This can occur if you omit the owner name from the replication scheme definition and the system uses the Id of the replication scheme creator.
On SYSTEM1:
> ttIsql masterDSN Command> select * from ttrep.replications; < REPSCHEME , SYSTEM1 , C, 0, 0, -1 > 1 row found.
On SYSTEM2:
> ttIsql -connStr "dsn=subscriberDSN" Command> select * from ttrep.replications; < REPSCHEME , SYSTEM2 , C, 0, 0, -1 > 1 row found.
Check Table Owner
You can check the owner names assigned to the tables in each database by using the ttIsql tables command.
This example shows that the TAB table has a consistent owner name (REPL) in the databases on both SYSTEM1 and SYSTEM2.
| Output for SYSTEM1 | Output for SYSTEM2 |
|---|---|
|
|
This example shows the TAB table with inconsistent owner names, which were automatically assigned for each host.
| Output for SYSTEM1 | Output for SYSTEM2 |
|---|---|
|
|