My Oracle Support Banner

Cloning Oracle Transportation Management Database Schemas (Doc ID 2786512.1)

Last updated on JUNE 29, 2021

Applies to:

Oracle Transportation Management - Version 6.2.0 to 6.4.1 [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:

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

Naming Conventions

Prerequisites

There are two options available for cloning schemas.

  1. Clone entire schemas
  2. 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.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Details
 Step 1. Export Schemas
 Sample Command
 Step 2. Prepare Target Database
 Step 3. Import Schemas
 Sample Command
 Clone without TRANSIENT Data
 Step 1. Export Schemas
 Step 1.1 Export without TRANSIENT Data Tables
 Sample Command
 Step 1.2 Export TRANSIENT Data Tables Metadata Only
 Sample Command
 Step 2. Prepare Target Database
 Step 3. Import Schemas
 3.1 Import Schemas without TRANSIENT Data Tables into the Target Database Using the DUMP File Created in Step 1.1.
 Sample Command
 3.2 Import TRANSIENT Data Tables Metadata Only into the Target Database Using the DUMP File Created in Step 1.2.
 Sample Command
 Step 4. Post Import Tasks
 Step 5. Clean Up Data (Optional)
 Step 6. Review Oracle Transportation Management Configuration Data (Optional)
 Step 7. Modify Scalability Configuration Settings in the Database (Optional)

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.