This content has been marked as final. Show 10 replies
The tool is free.
Formal support is tied to your database licensing, otherwise you can post questions here.
There are premium database features accessible via SQL Developer. Use of those features is limited to those who have licensed the appropriate database features and packs.
Please let me know if you have any additional questions.
SQL Developer Product Manager
this/T͟His/Pronoun: Used to identify a specific person or thing close at hand or being indicated or experienced: "is this your bag?".
Adjective: Used to identify a specific person or thing close at hand or being indicated or experienced: "don't listen to this guy".
Adverb: To the degree or extent indicated: "they can't handle a job this big".
Synonyms: pronoun. it - that - this one - these
adverb. thus - so - that
This: "There are premium database features accessible via SQL Developer..."
No I have not "inspected the licensing preferences". Nor am I likely to spend my time doing so when I should be performing tasks I am paid to do.
SQL*Plus does not put the options in front of you. To use a premium feature in SQL*Plus you have to go and make an effort to look up the API and how to use it.
That is quite different from Oracle Marketing getting Jeff's development team to make all these options easily available. All you need to do to use a premium feature - and set auditing flags in the database to say you have used it - is click on a menu item. This enables inexperienced DBAs - and some experienced ones probably - and developers to use options the customer has not acquired licenses for, and Oracle Sales to beat customers up at the next review.
Such options should be disabled by default.
Had a look at the licensing preferences. In Tools-> Preferences -> Database -> Licensing. Only covers EM packs. Not additional cost features like some uses of Data Modeller, Data Miner, Advanced Compression, and what else? I don't know because I'm not employed as a licensing specialist.
And that's my point. Sites are put off choosing SQL Developer because managers have experienced Oracle Sales practice before and do not want to be hit with large fees for features they did not know they were using, or needed.
Data Modeler is not an additional cost feature.
There's no way to disable Partitioning, but you can use those same feature usage views to identity curtail usage of those features by developers who are not aware of what your license gives you access to.
You can remove data miner by disabling its extension in Preferences.
Grammar lesson aside, I appreciate your feedback here.
It's a tough balance to maintain -
If we hide the features, then people will assume they are not there.
If we expose the features, then some may abuse or misuse them.
However, Oracle Marketing doesn't drive features in SQL Developer. And it's not 'my' product, it's the community's product. The community and the database updates drive features.
If you have invested in premium database features, the IDE should support those. But, we do warn users before launching the diagnostic and tuning pack features that they require additional licensing. We could investigate taking that a step further to include other non Std licensing features. Please submit your suggestions to the Exchange.