Recently while importing a new physical schema from PostgreSQL 8.4 into Oracle Data Integrator(ODI) via JDBC driver all of the tables were reversing into the model without data types defined for text, double precision, smallint, integer and boolean. If one or two fields are missing it’s easy enough to set the data type manually for [...]
Archive for the ‘Oracle Data Integrator’ Category
Reverse PostgreSQL into model with undefined data types
Posted in Oracle Data Integrator, tagged data types, ODI, PostgreSQL, reverse on June 30, 2011 | Leave a Comment »
Scenarios listed in Operator view are same as Designer view
Posted in Oracle Data Integrator, tagged ODI, Oracle Data Integrator, Scenario on April 12, 2011 | Leave a Comment »
I’m currently using Oracle Data Integrator (ODI) 10.1.3 and I went to clean out the logs generated by the completed executions. I know there is a purge logs trash can icon, but I couldn’t do this because the ‘UNDO’ tablespace was full. Since I was getting this error I had to remove the reports manually. [...]
Error when purging log unable to extend tablespace ‘UNDO’
Posted in Oracle Data Integrator, tagged Data Integrator, log purge error, ODI, oracle express, ORA_30036 on April 11, 2011 | Leave a Comment »
Oracle Data Integrator 10.1.3 is a great tool and can even run fully functional against Oracle Express which is the only free Oracle database product available. Problem This limited database has it’s draw backs for production use. If Data Integrator is executing scenarios real time, or if the logs are never cleared it could quickly [...]
