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 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.



Leave a Reply 0

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