How To Run an OWB 11g Mapping From SQL*Plus Without Involving the Control Center Service
Last updated on MAY 09, 2017
Applies to:Oracle Warehouse Builder - Version 11.1 to 11.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Jun-2013***
All OWB tasks like Process Flows and Mappings can be executed using the script sqlplus_exec_template.sql. This script uses the OWB Control Center Service to manage the execution. For this reason, the Control Center Service should be "Available".
Process Flows will only run via the Control Center Service. But Mappings can be executed without the Control Center Service.
This note explains how to execute Mappings without involving the Control Center Service. It does not matter if this service is "Available" or "Not Available".
This method can be used for various reasons, such as:
- The OWB Target Platform is not certified for running the OWB Control Center Service.
- When a Mapping is configured for Manual Commit.
In this case, the mapping can e.g. be executed from SQL*Plus. After the execution, the user can decide to COMMIT or ROLLBACK the transaction.
- To enable a Session Trace on a Mapping.
To be able to enable a session trace on a Mapping, it is required to know in which session the Mapping is running. However, when running a mapping with the sqlplus_exec_template.sql, a new session is spawned in the database. This makes it difficult to enable the session trace.
When executing the Mapping as described in this note, no new session is spawned for the Mapping execution. Therefore it is more suitable for session tracing. For more information on this topic, refer to:
<Document 453777.1>: How To Perform a Session Trace on Mappings In OWB 11g
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms