Cannot Execute OWB 11.1 SQL Loader Mapping
(Doc ID 815449.1)
Last updated on JULY 29, 2019
Applies to:Oracle Warehouse Builder - Version 220.127.116.11 to 18.104.22.168 [Release 11.1]
Stand alone installation of OWB 11.1 on an Oracle 10gR2 database.
The following actions have been performed:
- Created the files source, including the file location.
- Created the target table.
- Created the mapping of files source to the target table. Configured the mapping, i.e. Control file location, Bad file location, discard file location, data file location are specified correctly .
- Validation and deployment of mapping is successful.
- While executing the mapping, mapping status shows SUCCESS and no further information available.
- In target table, no rows were inserted. The control file was created at the specified location, however, no bad file, log file or discard file exists.
- If the control file (created by OWB) is executed through the SQLLDR utility, rows are inserted into table, the log file, bad file, etc. are created in the specified location.
In the OWB runtime log, something similar to the following is observed:
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