My Oracle Support Banner

Export and import the entire OSM database - OSM schema, orders and model data (Doc ID 1600695.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Communications Order and Service Management - Version 7.0.1 to 7.2.4 [Release 7.0.0 to 7.2]
Information in this document applies to any platform.

Purpose

This document outlines how to do a complete export of an OSM Schema.

Note: The steps and procedures outlined in this KM Note are for import/export purposes only.  They are not to be used for other activities like system back up and restore.  For more information on how to back up and restore see the "Order and Service Management System Administrator's Guide".

Scope

 

For newer OSM versions including 7.3.0 and 7.3.1 see the "Order and Service Management System Administrator's Guide" for that specific release version.

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
Scope
Details
 Export/Import Setup
 Check for the OSM export/import utility om_exp_imp_util_pkg package
 Create the OSM export/import utility om_exp_imp_util_pkg package
 Take OSM offline
 Export
 Export the source schema
 Export the OM_T_ORCH_PROCESS type definition
 Print out the schema information
 Import
 Create the target schema user
 Create the OM_T_ORCH_PROCESS type
 Import to the target schema
 Import Errors
References

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