Oracle Data Modeller and synonyms -
I am searching the web for two days and still to generate a DDL code with the public synonyms Can not find the route . Would be very grateful for any advice.
I think you are working with two different and specific uses of the word "option ":
1) In logical (unit) modeling, synonyms are optional business names for one unit, e.g. Unit customer can have synonyms for PURCHASER and clients.
2) In the physical (database) model, the public synonyms are used to remove the need to specify the schema of a table. Generally, synonyms and table names are the same "create a public SYNONYM client for MYSCHEMA.CUSTOMERS";
Comments
Post a Comment