Skip to Content
Former Member
Nov 03, 2015 at 06:26 AM

Can we add rows to VM$_TMP_WIP_TABLES, to create additional synonyms in ODS?


We would like to add two more synonyms to the ODS, which will point back to tables in WIP, via the database link. There are 59 synonyms now in our ODS (ME 6.1.4). Those are generated by Oracle stored procedure Create_ODS_Synonym_Proc, based on the 59 rows in VM$_TMP_WIP_TABLES. Would there be any harm if we would add two rows to that table, in order to force the core procedure to generate our two additional synonyms? Would it work?