Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using SQL Developer to compare DDL

C PatelAug 23 2013 — edited Aug 27 2013

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 24 2013
Added on Aug 23 2013
#sql-developer
2 comments
451 views