What happens to the PL/SQL procedure after the online table redefinition?

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 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 becomes invalid only if the storage parameters have been modified and it automatically
gets revalidated the next time it is used.

B.
It becomes invalid for all options of online table redefinition and is automatically
recompiled during online redefinition of the table.

C.
It remains valid.

D.
It becomes invalid for all options of online table redefinition but automatically gets
revalidated the next time it is used.



Leave a Reply 0

Your email address will not be published. Required fields are marked *