Hello,
I've just started using Data Modeler 4.0.1 (upgrading from 3.3.0) and when generating DDL, I noticed that the name of my public synonyms are being generated with a schema prefix (which causes an error when trying to load them), where in the old version, the did not.
Example...If my schema is SCOTT and I had a public synonym for EMPLOYEE, the correct DDL generated would be:
CREATE PUBLIC SYNONYM EMPLOYEE
FOR SCOTT.EMPLOYEE;
This is how it was generated in 3.3.0, however in 4.0.1 I get:
CREATE PUBLIC SYNONYM SCOTT.EMPLOYEE
FOR SCOTT.EMPLOYEE;
Which will produce:
CREATE PUBLIC SYNONYM SCOTT.EMPLOYEE FOR SCOTT.EMPLOYEE
*
ERROR at line 1:
ORA-00905: missing keyword
This could very well be a setting that was not propagated when I upgraded, but I have yet to find it. Please let me know if anyone else experiences this and knows of a setting/workaround, or if it might be a bug and I'll have to revert back to 3.3.0.
Thanks!