My Oracle Support Banner

How To Make an Entire Repository Export With OWB 11.2 Using OMB*Plus Scripting Language (Doc ID 1581864.1)

Last updated on OCTOBER 11, 2018

Applies to:

Oracle Warehouse Builder - Version and later
Information in this document applies to any platform.


OWB 11.2 provides a way to make an Entire Export of the Repository using the Repository Assistant. The Entire Export contains both metadata and runtime data and is considered to be a supported backup of the OWB repository. The metadata consists of the design of OWB projects such as tables, mappings, flows etc. Runtime data consists e.g. of deployment information that can be seen in the Control Center, but also audit information that tells how many rows were loaded at a specific date/time. 

Customers might want to schedule such exports unattended in order to have valid backups of the complete OWB Repository. In such case the export would need to be made using OMB*Plus scripting language. This document explains how OMB*Plus can be used to make the Entire Repository Export using OMB*Plus scripting language. Also it explains how to execute the OMB*Plus export command from a shell script or batch file.


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
 1. The Entire Export command
2. How to execute the script directly from the Operating System

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