My Oracle Support Banner

Export and import OSM model data and a range of orders from a large database schema. (Doc ID 1600731.1)

Last updated on JULY 05, 2018

Applies to:

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

Purpose

This document outlines how to replicate an OSM schema with a subset of orders from a large 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".

Scope

 

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 the OSM order data
 Part one: Export order tables that define an order_seq_id
 Different examples of how to select orders to export
 Part two: Export order tables that use a different name for the order ID column
 Different examples of how to select orders to export
 Export the OSM model data
 Print out the schema information
 Prepare the target OSM schema before import
 Create the target OSM schema
 Add partitions
 Disable constraints, triggers, and stop jobs before import
 (Optional) Purge existing OSM orders and or model
 Import the OSM model data
 Import the OSM order data
 Part one: Import order tables that use a different name for the order ID column
 Part two: Import order tables that define an order_seq_id
 Finalize the target OSM schema after import
References

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