4 Replies Latest reply on Aug 26, 2014 9:28 AM by David Last-Oracle

    unable to obtain alter script from data modeler

    be here now
    be here now Aug 24, 2014 9:48 AM

      Hi,

       

      I am trying to compare my model (reverse-engineered from a ddl script and slightly modified afterwards) with an existing schema in Oracle DB and obtain an ALTER script. I press "synchronize data dictionary with model", then I choose my connection and observe object tree. Apparently there is a difference:

      Capture.PNG

      After this I press "DDL preview" and expect to see an "alter table FACT_FREIGHT_CARS" script there, but for some reason the window is empty and no script is generated:

      Capture2.PNG

      Is there a specific reason for this?

       

      I am using SDDM 4.0.2.840.

       

      Thanks,

      Kirill

        • 1. Re: unable to obtain alter script from data modeler
          be here now
          be here now Aug 24, 2014 9:36 PM (in response to be here now)

          I managed to get an expected alter script by importing existing data dictionary from database into a whole new design, changing it and then syncing my changed design back with data dictionary.

          I tried to compare two designs - one reverse-engineered from ddl script, another one reverse-engineered from data dictionary - with each other, but still got blank screen in "DDL Preview". Probably a bug?

          1 person found this helpful
          • 2. Re: unable to obtain alter script from data modeler
            Philip Stoyanov-Oracle
            Philip Stoyanov-Oracle Aug 25, 2014 7:42 AM (in response to be here now)

            After this I press "DDL preview" and expect to see an "alter table FACT_FREIGHT_CARS" script there, but for some reason the window is empty and no script is generated:

            Probably there is an error preventing that. Can you check the log file for errors logged there - use "View>External log".

            At least you should get the following template if thee is nothing to be generated:

            -- Generated by Oracle SQL Developer Data Modeler 4.0.2.840

            --   at:        2014-08-25 10:40:58 EEST

            --   site:      Oracle Database 11g

            --   type:      Oracle Database 11g

             

             

             

            -- Oracle SQL Developer Data Modeler Summary Report:

            --

            -- CREATE TABLE                             0

            -- CREATE INDEX                             0

            -- CREATE VIEW                              0

            -- ALTER TABLE                              0

            -- ALTER INDEX                              0

            -- DROP TABLE                               0

            -- DROP INDEX                               0

            -- CREATE TRIGGER                           0

            -- ALTER TRIGGER                            0

            -- CREATE SEQUENCE                          0

            -- ALTER SEQUENCE                           0

            -- DROP SEQUENCE                            0

            -- CREATE MATERIALIZED VIEW                 0

            -- DROP VIEW                                0

             

            --

            -- ERRORS                                   0

            -- WARNINGS                                 0

             

             

            Philip

            • 3. Re: unable to obtain alter script from data modeler
              be here now
              be here now Aug 26, 2014 1:19 AM (in response to Philip Stoyanov-Oracle)

              Probably there is an error preventing that. Can you check the log file for errors logged there - use "View>External log".

              No, there are no errors in the log file, at least at the time I try to generate DDL (there are some irrelevant from a few days ago).

              • 4. Re: unable to obtain alter script from data modeler
                David Last-Oracle
                David Last-Oracle Aug 26, 2014 9:28 AM (in response to be here now)

                Hi,

                 

                Are there any other Tables, Views, ... with differences?  Are there any other differences identified for Table FACT_FREIGHT_CARS (e.g. PK, UK or Foreign Key or Table Check Constraints)?

                What is the datatype of column SOMETHING?

                 

                I assume standard DDL generation for your model is working fine?

                If you could post the standard DDL for table FACT_FREIGHT_CARS (and any other Tables, Views, etc with differences) that would probably help to identify the cause of the problem..

                 

                Thanks,

                David