This content has been marked as final. Show 6 replies
OWB 11.2 is also certified for Oracle 10g (which is also indicated by my quote from the manual, that mentions 10g), Oracle provides a stand-alone version of OWB 11.2 for this purpose. Besides, row-based update-mappings are already a feature in OWB 10.1.
So my question remains.
We're getting off-topic here, but allright. I read the page you referred to, and I can't find the text that supports you assertion. It says among others
"Compatibility with Oracle Database
Database Release Compatible Warehouse Builder Releases
DB10gR2 Warehouse Builder 10.2, 11.1, and 11.2
Enterprise Edition Certified for use of all OWB functionality including additional cost licenses" [this is our database version]
For me this implies that OWB 11.2 can be used on a 10.2 database.What other part of the text says or implies that OWB 11.2 is only certified for database 11.2?
Furthermore, In the "Oracle® Warehouse Builder Installation and Administration Guide 11g Release 2 (11.2) for Windows and Linux", chapter "Working with the Standalone Install Package" it reads:
"There are several situations when you must download and install the
OWB 11g Release 2 Standalone Install Package:
■ You are installing OWB 11.2 and hosting an OWB Repository on one of:
Oracle Database 10g Release 1, Oracle Database 10g Release 2, or
Oracle Database 11g Release 1
To get on-topic again: have you ever succeeded in generating an SET_BASED UPDATE-mapping on a configuration that is, to your opinion, certified?
to get on topic again, I use set-based mappings exclusively because row-based is too slow
all simple mappings like you have described should be set-based per default unless you have specified in the configuration of the mapping that it should generate something else.
And I can only stress the fact that you should not try to run OWB 11.2 in another DB than 11.2.
sorry if that can not help you solving the issue
I found the limiting factor. As mentioned before we are migrating from a previous version. Thios version deployed in a 9i database. To enable OWB 11gR2 to generate a SET_BASED mapping the module configuration property 'PL/SQL Generation Mode' has to be set to 'Oracle 10gR1' or higher. It was 'Oracle 9i', preventing OWB from generating the mapping SET_BASED. When I changed the property to 'ORAcle 10gR2' the mapping genreated SET_BASED without a problem.