SQL Developer Does not Generate DDL on SQL tab

User_X5645

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.

thatJeffSmith-Oracle

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

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

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.