Why do the Spotlight User installation scripts drop SYS.EXECUTE_IMMEDIATE and SYS.BUILD_XVIEW when Oracle 11gR2 do not contain them? (4279240)

立即与支持人员聊天

标题

Why do the Spotlight User installation scripts drop SYS.EXECUTE_IMMEDIATE and SYS.BUILD_XVIEW when Oracle 11gR2 do not contain them?
说明

The Spotlight user creation script, install_post11gR2.sal, has DROP statements for SYS.EXECUTE_IMMEDIATE and SYS.BUILD_XVIEW.
...
BEGIN
EXECUTE IMMEDIATE 'DROP PROCEDURE SYS.EXECUTE_IMMEDIATE';
EXCEPTION WHEN OTHERS THEN null;
END;
BEGIN
EXECUTE IMMEDIATE 'DROP PROCEDURE SYS.BUILD_XVIEW';
EXCEPTION WHEN OTHERS THEN null;
END;
...
Why do the installation script drop SYS.EXECUTE_IMMEDIATE and SYS.BUILD_XVIEW when Oracle 11gR2 do not contain them?

要求登录

您需要登录并且已签署最新的维护合同，才可查看 高级知识文章。

建议的内容