Cloning Oracle Transportation Management Database Schemas (Doc ID 2786512.1)

Last updated on OCTOBER 03, 2024

Applies to:

Oracle Transportation Management - Version 6.2.0 to 6.4.2 [Release 6.2 to 6.4]
Information in this document applies to any platform.

Purpose

This document explains how to copy Oracle Transportation Management database schemas from one database to another. This procedure could be used, for instance, to copy production Oracle Transportation Management database schemas to a test database.

Note: This no longer applies to newer version of OTM from 6.4.2. For 6.4.2 onwards, it is best to copy entire production database and duplicate it at the database level instead of schema level.

Method

The following method will be used to perform schema cloning:

Export Oracle Transportation Management schemas of the source database using data pump.
Prepare destination database.
Import Oracle Transportation Management schemas into the destination database using data pump.
Perform post import tasks which recompiles objects, creates remaining objects and perform grants.
Modify configuration data to reflect new database in the Oracle Transportation Management configuration tables.

Naming Conventions

Source database: Database from where Oracle Transportation Management schemas and data is being copied.
Target database: Database to where Oracle Transportation Management schemas and data are being copied.
TRANSIENT data: Temporary data which is no longer required by Oracle Transportation Management for day to day functionality.
Data pump: Oracle Database utility to export and import schemas.
DATAPUMP DIRECTORY: Directory on the database server available to store exported schema and data.

Prerequisites

Oracle Transportation Management application version of target database should be the same as source database.
Target database should be installed with proper Oracle Transportation Management init.ora parameters similar to source.
Source and Target database has DATAPUMP DIRECTORY created and proper disk space and permissions are available to user.
Person performing this task needs basic DBA skills as well as person must have used Data Pump previously. Refer to Oracle Database Utilities 11g Release 2 document to get more information about Data Pump.

There are two options available for cloning schemas.

Clone entire schemas
Clone without TRANSIENT data

The second option can significantly reduce runtime and disk space during copy process. This option can be used to copy production database to development systems.