My Oracle Support Banner

Export and import from a large OSM database schema (Doc ID 1594152.1)

Last updated on MARCH 15, 2023

Applies to:

Oracle Communications Order and Service Management - Version 7.0.1 and later
Information in this document applies to any platform.


This document outlines how to replicate an OSM schema. Exporting a large schema, with hundreds of thousands or millions of orders, can be impractical due to its size, the time it takes, and resources it requires to export. A more feasible solution is to selectively export specific orders, or a range of orders.

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 example executing the om_exp_imp_util_pkg.purge_model procedure without a model export to restore the data will result in a non functioning OSM schema. For more information on how to back up and restore see the "Order and Service Management System Administrator's Guide".




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
 Export and import scenarios
 Document ID: 1601055.1 - Export and import OSM model data from a large database schema - OSM model data only.
 Document ID: 1600747.1 - Export and import OSM model data and a single order from a large database schema.
 Document ID: 1600731.1 - Export and import OSM model data and a range of orders from a large database schema.
 Document ID: 1600697.1 - Export and import an additional range of orders from a large database schema. (Used when the OSM model already exists in the target schema).
 Document ID: 1600695.1 - Export and import the entire OSM database - OSM schema, orders and model data.
 After Import

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