1. Replication Guide
  2. Defining Classic Replication Schemes
  3. Establishing the Databases

Establishing the Databases

You can replicate one or more tables on any existing database.

If the database you want to replicate does not yet exist, you must first create one, as described in Managing TimesTen Databases in Oracle TimesTen In-Memory Database Operations Guide.

After you have identified or created the master database for the classic replication scheme, create a DSN definition for the subscriber database on the target host. Set the connection attributes for the master and subscriber databases as described in Connection Attributes for Replicated Databases.

After you have defined the DSN for the subscriber, you can populate the subscriber database with the tables to be replicated from the master in one of two ways:

  • Connect to the database and use SQL statements to create new tables in the subscriber database that match those to be replicated from the master.

  • Use the ttRepAdmin -duplicate utility to copy the entire contents of the master database to the subscriber. See Duplicating a Master Database to a Subscriber.