Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Where can I set the "Drop type force" preference in SQL Developer?

niallmcpOct 15 2015 — edited Oct 15 2015

Hi,

When dropping a type in SQL Developer 4.1, I get the following message:

   ORA-02303: can't drop or replace a type with type or table dependents. SQLDev advises setting "Drop Type Force" preference

I know how to force drop the type with a SQL command - so that's not an issue.

My question is "Where can I set the "Drop Type Force" preference?"

Many thanks for any help with this.

Niall.
This post has been answered by unknown-7404 on Oct 15 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2015
Added on Oct 15 2015
#sql-developer
5 comments
6,017 views