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
Thank you for your reply. That is great. It works well!
Thank you lots.
I have the same error trying to reverse a synonym from oracle... ODI doesn't show the columns or constrains but i'm not using different schemas... source table and synonym are at the same schema, any suggestion.
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.