在系统迁移、升级过程中,一般需要筛查对比数据库对象的有效性是否前后一致,发现不一致后需要批量重新编译:
点击(此处)折叠或打开
- --PROCEDURE
- ALTER PROCEDURE procedure_name COMPILE;
- --FUNCTION
- ALTER FUNCTION function_name COMPILE;
- --PACKAGE
- ALTER PACKAGE package_name COMPILE SPECIFICATION;
- ALTER PACKAGE package_name COMPILE BODY;
- --MATERIALIZED VIEW
- ALTER MATERIALIZED VIEW MV_NAME COMPILE;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29599494/viewspace-2106775/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29599494/viewspace-2106775/