1. 查看数据库中的无效对象 check oracle object SQL> select count(*) from dba_objects where status='INVALID'; 2. 关闭应用,数据库和监听不能关闭 cd $ADMIN_SCRIPTS_HOME ./adadstpall.sh apps/apps 3. 用APP用户,执行adadmin打开维护模式并重新编译APPS Schema; 打开维护模式 adadmin->Change Maintenance...
后来在StackOverFlow看到了这个,原文链接如下: https://stackoverflow.com/questions/48497140/oracle-sql-stored-procedure-object-invalid 楼主在里面发现了这么一句话: You can’t give a size or precision restriction forthe data type of a formal parameterto a function or procedure, soNUMBER(10,0)should ...
后来在StackOverFlow看到了这个,原文链接如下: https://stackoverflow.com/questions/48497140/oracle-sql-stored-procedure-object-invalid 楼主在里面发现了这么一句话: You can’t give a size or precision restriction for the data type of a formal parameter to a function or procedure, so NUMBER(10,0) s...
-- 重新编译单个存储过程 ALTER PROCEDURE my_procedure COMPILE; -- 重新编译所有无效的存储过程 SELECT 'ALTER PROCEDURE ' || OBJECT_NAME || ' COMPILE;' FROM USER_OBJECTS WHERE STATUS = 'INVALID' AND OBJECT_TYPE = 'PROCEDURE'; 自动重新编译脚本示例: ...
all_objects:ower,object_name,subobject_name,object_id,created,last_ddl_time,timestamp,status等 获取表字段 代码语言:javascript 代码运行次数:0 运行 AI代码解释 select * from user_tab_columns where Table_Name='用户表'; select * from all_tab_columns where Table_Name='用户表'; select * from ...
SQL> select * from dba_objects t where t.status = 'INVALID' order by 1; 1. 2.编译无效对象 select 'alter '||object_type||' '||owner||'.'||object_name||' compile;' from dba_objects t where t.status = 'INVALID' order by 1; ...
Oracle BAM Adapter can communicate with Oracle BAM Server through Enterprise JavaBeans (EJB) (if they are deployed in the same farm), direct Java object invocations (if they are deployed in the same container) or through Web Services (if 1-2 Oracle Fusion Middleware User's Guide for Oracle...
ORA-12170:TNS:Connect timeout occurred，说明CPSETL.BI_FEED_CUSTOMER_SNAPSHOT里有远程dblink涉及，需要具体诊断该远程dblink访问问题。
Cause:The object to be described is not valid. It either has compilation or authorization errors. Action:The object to be described must be valid. Database:11g Release 2 Error code:ORA-24372 Description:invalid object for describe Cause:The object to be described is not valid. It either has...
如果一个对象的定义中引用了其他对象,那么此对象被称为依赖对象(dependent object),此对象所引用的对象被称为引用对象(referenced object)。为了管理方案对象(schema object)间的依赖关系,Oracle 需要记录所有的方案的状态(status): 有效的(valid)已经通过编译,可以在被引用时直接使用。 无效的(invalid)必须在使用之前...