Compiling Schema Objects

Last modified: October 23, 2019

If a view, package, object, or stored procedure is invalid you have to compile it to make it work. Schema objects can be compiled by right-clicking the node in the Database Explorer window, and choosing corresponding command from the Compile shortcut menu.

Compiling Dependants and References

When you change an object, its descendants can become invalid. In such cases you may need to recompile them. dbForge Fusion allows you to compile object’s dependants and references. To do this, right-click the node in Database Explorer and choose corresponding command from the Compile shortcut menu.