1.手动编译
如果无效对象的数量很少,那么你可以逐个编译这些对象.
如
ALTER PACKAGE my_package COMPILE;
ALTER PACKAGE my_package COMPILE BODY;
ALTER PROCEDURE my_procedure COMPILE;
ALTER FUNCTION my_function COMPILE;
ALTER TRIGGER m...
执行存储过程时,execute和call的区别
EXEC is a sqlplus command that put its argument as an anonymous pl/sql block: 'EXEC xxx' is transformed to 'BEGIN xxx; END;' So you can use it to call a procedure, or do any ...
AD 工具中有一个相当重要的,就是 AutoConfig。主要是简化和标准化配置管理任务。参考文档:
Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12 (文档 ID 387859.1)
R12 将所有的配置参数集中在 context file 中, app tier 一个c...