I create a view(without FORCE syntax) and I run the SQL scripts. Then I go to Schema Browser | Views tab and go to scripts. The CREATE OR REPLACE script includes the FORCE VIEW syntax. Why ? I created a regular view but TOAD adds â??FORCEâ?? automatically.
Oracle doesnt remember if you create the view with or without the FORCE keyword. That has no bearing on how if that keyword will be present or not when the script is created in the future
Script creation settings can be adjust by running an Export DDL job. The settings used to create this script will be applied throughout Toad.
1. Go to Database | Export | Export DDL
2. Go to the Objects & Output tab.
3. Add a view to create a script for (does not matter what is chosen since the script that is created can be disregarded).
4. Below, under Output section, choose Screen
5 Go to the Script Options tab | View tab.
6. Unselect Force to disable the option to include FORCE syntax.
7. Click the Green Arrow icon to Export Object DDL (you will need to run this at least once to apply the setting).
A script for the chosen view will be crated and outputted to a new window. The resulting script can be disregarded and the window closed. Since the FORCE option was disabled, the view script created will not include FORCE syntax. Toad will save these setting and apply it to all instances where a script is created (until you change this setting). To verify this, go to Schema Browser | View tab | Script tab (hit refresh) and check that the script in schema browser is also now created without FORCE.
Other script creation setting for other objects can be adjusted this way.
At least one script needs to be created for the changes to be applied in Toad
This will apply throughout Toad for script creation.