This discussion is archived
2 Replies Latest reply: Jul 28, 2010 2:24 PM by 788006 RSS

SQL Developer hangs when Generating DDL

788006 Newbie
Currently Being Moderated
I created a view in my database using SQL Developer version 2.1.1 (for Mac). Now when I click the SQL tab on the view editor a message box pops up saying "Generating DDL..." This runs for several minutes until the connection finally times out. The eventual error message says "Generation of DDL failed"

Any Idea what the problem could be?
  • 1. Re: SQL Developer hangs when Generating DDL
    BelMan Expert
    Currently Being Moderated
    Bugs Fixed since Oracle SQL Developer 1.5.1 was released in June 2008.
    Oracle SQL Developer 1.5.5 is scheduled for inclusion in Oracle Database 11gR2. It has a few code fixes on top of those added in release 1.5.3 and 1.5.4. This list of bugs fixed is a combination of fixes in 1.5.3, 1.5.4 and 1.5.5 and is not all-inclusive. For the list of bugs fixed between SQL Developer 1.5.0 and SQL Developer 1.5.1


    see this link
    http://www.oracle.com/technology/products/database/sql_developer/files/BugsFixed_v155.html
  • 2. Re: SQL Developer hangs when Generating DDL
    788006 Newbie
    Currently Being Moderated
    As stated, I'm running version 2.1.1 (specifically version 2.1.1.64.45 which I believe is the latest version). Wouldn't the bugs fixed since 1.5.1 be in this version?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points