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!

View DDL force option wrong on SQL tab

themarmanJul 20 2015 — edited Jul 21 2015

If I create a view

create view X as select * from dual;

the default for FORCE/NO FORCE should be NO FORCE https://docs.oracle.com/database/121/SQLRF/statements_8004.htm

but when I create this view and open it in 4.1.19.59 the SQL tab always includes FORCE. The export utility also defaults to FORCE but is at least configurable. I have not been able to find a preference to control this behavior.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2015
Added on Jul 20 2015
#sql-developer
2 comments
992 views