Forum Stats

  • 3,837,228 Users
  • 2,262,239 Discussions


SQL Develpoer - Showing Empty SQL script when generating DDL

User_48AND Member Posts: 1 Green Ribbon


I have encountered a problem when trying to generate SQL(with DDL) for a table. I noticed the problem only occurs when I'm not logged into same schema as the table whose SQL script I try to generate. But I can see all the data from tables and other stats. For the ones I don't have privileges I get an error which expected behavior. Here are some screenshots.

In the 'SQL' tab:

When I generate it with 'Quick DDL':

When using 'Save to Clipboard' I get an empty result. When saving to file:

Also when saving to Worksheet I get an empty result.

Has anyone encountered the same problem? Is this expected behavior or could it be a bug?

I'm using:

  • SQL Developer Version: Build 173.2018
  • Java(TM) Platform
  • Oracle IDE
  • Versioning Support