Oracle Audio Technologies Retail Place 12.2 用户手册

Creating the Database Links

Setting Up the Database

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:

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';

 

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';

The dblink_name_elm2base and dblink_name_base2elm indicate 

the name of a database links you create between the instances.