Oracle Audio Technologies Oracle Retail Place 12.2 - Manual (Page 21)

Creating the Database Links
Setting Up the Database 3-3
Creating the Database Links
If you plan to install the Place application across two database instances, you must
create the instances in the following manner, and then set up the database links
between the two instances:
■
Set up the ELM schema (historical data) on a database instance
(for example, INSTANCE1).
■
Set up the remaining database schemas (PLACE, AUDIT, OAK, and PINE schema)
as a single BASE schema, on the other database instance
(for example, INSTANCE2).
To create the database links:
1. At the SQL prompt, connect to the ELM schema on INSTANCE1, and then run the
following command:
create database link <dblink_name_elm2base> connect to ELM identified by BASE
using 'INSTANCE1';
2. At the SQL prompt, connect to the BASE schema on INSTANCE2, and then run
the following command:
create database link <dblink_name_base2elm> connect to BASE identified by ELM
using 'INSTANCE2';
Note: The dblink_name_elm2base and dblink_name_base2elm indicate
the name of a database links you create between the instances.