A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the
online table redefinition. What happens to the PL/SQL procedure after the online table
redefinition?
A.
It remains valid
B.
It becomes invalid for all options of online table redefinition but automatically gets revalidated
the next time it is used
C.
It becomes invalid for all options of online table redefinition and is automatically recompiled
during online redefinition of the table
D.
It becomes invalid only if the storage parameters have been modified and it automatically gets
revalidated the next time it is used
Minimize Dependent PL/SQL Recompilation After Online Table Redefinition
This feature minimizes the need to recompile dependent PL/SQL packages after an online table redefinition. If the redefinition does not logically affect the PL/SQL packages, recompilation is not needed. This optimization is on by default.
This feature reduces the time and effort to manually recompile dependent PL/SQL after an online table redefinition. This also includes views, synonyms, and other table dependent objects (with the exception of triggers) that are not logically affected by the redefinition.