My Oracle Support Banner

How To Export and Import an OTM 5.5 DB Instance (Doc ID 1232024.1)

Last updated on MAY 04, 2018

Applies to:

Oracle Transportation Management - Version 5.5.01 to 5.5.06.03 [Release 5.5]
Information in this document applies to any platform.
***Checked for relevance on 14-Aug-2014***

Goal

The following instructions are intended to help explain one way of exporting the data from an Oracle Transportation Management ( OTM ) Database instance and importing the data into a new Database instance.

Note: The instructions do not cover the additional steps required for OTM instances with Fusion Transportation Intelligence ( FTI ) installed or ROD Database instances.

Solution

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
Goal
Solution
 Exporting Data from an OTM Instance
 Creating the New Database
 Creating the tnsanames.ora for the New Database
 Creating the OTM Tablespaces, Users and Roles
 Importing the Data
 Running the Post Import Scripts
References

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