Oracle Data Modeller and synonyms

I've been searching the web for two days and still cannot find a way to generate DDL code with public syn开发者_如何学运维onyms. Would be very grateful for any advice.

I think you are dealing with two different and distinct uses of the term "synonym":

1) In logical (entity) modelling, synonyms are alternative business names for an entity, e.g. the entity CUSTOMER may have synonyms PURCHASER and CLIENT.

2) In the physical (database) model, public synonyms are used to remove the need to specify the schema that owns a table. Commonly, the synonym and table name are the same e.g. "CREATE PUBLIC SYNONYM customers for MYSCHEMA.CUSTOMERS;"

It would be very unusual to want public synonyms generated in the database for the business synonyms defined in the logical model.