Forum Stats

  • 3,768,631 Users
  • 2,252,824 Discussions
  • 7,874,658 Comments

Discussions

SQL Developer Does not Generate DDL on SQL tab

User_X5645
User_X5645 Member Posts: 2 Green Ribbon
edited Sep 8, 2021 4:44PM in SQL Developer

Hi,

I recently upgraded my SQL Developer to Version 20.4.1.407.0006.

After the upgrade, SQL Developer does not generate SQL Script on Views.

Please let me know if I have to make any changes in the Preferences.



Answers

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 8,060 Employee

    Well, you could upgrade again to 21.2.1

    But also, what version of Oracle Database are you logged into, and are you logged in as the owner of AS_STUDENT_DATA view?

  • User_X5645
    User_X5645 Member Posts: 2 Green Ribbon

    Hi thatJeffSmith-Oracle,


    I am not the owner. However, I was able to view the SQL (DDL) in SQL developer Version 19.1.



    Also, I can see the code in the Details Tab (TEXT) but not in SQL tab. I tried upgrading it to 21.2.1 with the same problem.


  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Distinguished Product Manager Posts: 8,060 Employee

    In older versions we would try to query the data dictionary to get the object DDL if you didn't have the privs for DBMS_METADATA package to generate DDL from the database itself. We no longer do this, if DBMS_METADATA doesn't work, you don't get any DDL for your object.

    It's most likely this is causing your issue - ask your DBA to elevate your account privs.


    The TEXT field there in the Details tab gives you the most important part of the DDL behind your view as a workaround.