DBA > Job Interview Questions > Oracle DBA Interview questions and Answers

What is difference between COMPILE_ALL=SPECIAL a

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is difference between COMPILE_ALL=SPECIAL and COMPILE=ALL while compiling Forms ?

Both the options will compile all the PL/SQL in the resultant .FMX, .PLX, or .MMX file but COMPILE_ALL=YES also changes the cached version in the source .FMB, .PLL, or .MMB file. This confuses version control and build tools (CVS, Subversion, make, scons); they believe you've made significant changes to the source. COMPILE_ALL=SPECIAL does not do this.

(Continued on next question...)

Other Job Interview Questions