3 Replies Latest reply on May 6, 2014 11:18 AM by David Last-Oracle

    Public Synonyms Generating with Schema Prefix in Data Modeler 4.0.1

    user7190084

      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!