2 Replies Latest reply: Aug 27, 2013 9:47 AM by C Patel RSS

    Using SQL Developer to compare DDL

    C Patel

      Is it possible to use Oracle SQL Developer to compare the DDL of a particular table with either:

      1. The same table in the same schema, different database
      2. With a file which contains the DDL of an object
      3. A different table in the same schema, same database
      4. A different table in the same schema, different database

       

      I have a table FOO.MY_TBL@DB1.  I would like to compare it to FOO.MY_TBL@DB2.  Likewise, I would also like to compare FOO.MY_TBL@DB1 with a file I have saved on my computer named my_tbl.sql, which contains the DDL of the table.

       

      However I also have a need to compare it to FOO.MY_TBL_CPY@DB1 or even to FOO.MY_TBL_CPY@DB2.

       

      Are any of these possible?  I have not tinkered enough with the Tools --> Database Diff feature, but it seems that it can only perform #1 above.

       

      Oracle SQL Developer Version 4.0.0.12