This content has been marked as final. Show 4 replies
ODI allows you to reverse the OPE_OWNER Objects without using the OPE_OWNER password.
1) Grant select any table on OPE_OWNER table's to OPE_READ_ONLY (or some tables).
2) Create a server on ODI the user should be OPE_READ_ONLY
3) Create a physical Schema and select
OPE_OWNER in (Schema) and OPE_READ_ONLY in (Work Schema).
You can now reverse all the tables from OPE_OWNER using the standard reverse or the RKM Oracle.
If you have to reverse only synonyms, you have to update the RKM
You don't have to have different schema... the problem is that the standard reverse didn't reverse synonyms. The RKM Oracle provided by ODI don't do the job!
If you know how to query the table "ALL_SYNONYMS" from oracle Database, it will be easy you to adapt the RKM Oracle and to reverse the synonym.