
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved.
Domain Copy
Oracle Transportation Management provides utilities to copy domains between Oracle Transportation
Management databases. There are two approaches to copy domains. The first one uses a PL/SQL
procedure to generate INSERT statements with domain data to be copied from the source database.
The insert statements can be run in the target database. The second approach uses Oracle Database
TABLE mode export/import with WHERE clause to move domain data between source and destination
databases. Please refer to the Oracle Transportation Management document titled “Data Management
Guide” for details of this method.
Features/Limitations:
Can be used between different platforms and different operating systems.
Oracle Database version in the target environment must be equal or higher than that in the
source environment if using export/import approach.
Requires pre-creating an Oracle Database and installing an Oracle Transportation Management
database in the target environment.
Oracle Transportation Management table structures must be identical between the source and
target database.
Can just move one or more domain data between the databases.
Using WebLogic GridLink Data Source
Oracle Transportation Management can be configured to use GridLink Data Source defined in
WebLogic.
Note: This configuration requires you to stop and start Oracle Transportation Management.
In order to set up to use an external data source, you need to do the following steps. Oracle
Transportation Management may not start if all steps are not completed.
1. Create Data Source in WebLogic Console
2. Update Database for Data Source
3. Modify startup scripts on server
Create Data Source in WebLogic Console
Navigate to the WebLogic console.
Login as system user.
Follow WebLogic guidelines to Configure GridLink for RAC Data Source.
o DO NOT create the Data Source name with prefix PRIMARY.
o Remember the name of the Data Source and the JNDI name of this Data Source. In
this example, the name of the Data Source is CUSTOM_DS and the JNDI name of the
Data Source is CUSTOM
Note: You will see an existing Data Source named PRIMARY_JTS. You can ignore this connection.
Update Database for Data Source
Create a new data source and assign data functions to this data source using SQL scripts.
Note: See the Changing Passwords section of the Oracle Transportation Management
Security Guide for more information on encoding password for user glogdba.
Kommentare zu diesen Handbüchern