My Oracle Support Banner

How To Purge Orders In OSM Using "Drop Partition", "XMLIE", "Design Studio" and " SQL Script" (Doc ID 1420553.1)

Last updated on SEPTEMBER 05, 2018

Applies to:

Oracle Communications Order and Service Management - Version 6.1 to 7.0.2 [Release 6.1 to 7.0.0]
Information in this document applies to any platform.
Currency checked on 13-Feb-2015
***Checked for relevance on 05-Aug-2018***


List different ways of performing an OSM order purge.



This document is only applicable for older releases of OSM.  OSM 7.0.3. customers and higher should refer to OSM 7 Database Management (DocID 1556202.1)

Questions and Answers

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
Questions and Answers
 How to Drop Partition ( Recommended)
 How to remove orders through XMLIE
 Purge the orders through undeploying the cartridge using Purge script:
 Running the Purge Command On UNIX or Linux:
 Running the Purge Command On Windows:
 Purge the orders using OrderPurge script:
 Running the OrderPurge Command On UNIX:
 Running the OrderPurge Command On Windows: 
 How to undeploy the cartridge using Design Studio
 How to remove the orders using SQL Script( order_remove)

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