Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?



Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question