SQL> SET LINES 333 PAGES 111 SQL> COL OBJECT_NAME FOR A40 SQL> COL OBJECT_TYPE FOR A30 SQL> COL OWNER FOR A25 SQL> SELECT OWNER, OBJECT_TYPE,COUNT(*) OBJECT_COUNT FROM DBA_OBJECTS WHERE STATUS <> 'VALID' 2 GROUP BY OWNER,OBJECT_TYPE order by OWNER,OBJECT_TYPE; OWNER OBJECT_TYPE...
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...
Below is the query to find the invalid objects currently present in the database. set pagesize 200 set lines 200 select owner,object_name,object_type,status from dba_objects where STATUS='INVALID'; 1. Compile all the objects of the database using UTLRP.SQL. This script may take some ti...
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...
FROM dba_objects WHERE status = 'INVALID'; 2、检查不起作用的约束: SELECT owner, constraint_name, table_name, constraint_type, status FROM dba_constraints WHERE status = 'DISABLED'; 3、检查无效的触发器: SELECT owner, trigger_name, table_name, status ...
FROM dba_objects WHERE status = 'INVALID' ORDER BY 1 , 2, 3 ; 编译失效的对象: 1: 使用ALTER *** COMPLIE语句手工进行编译,这个适用于少数、个别对象失效 alter package <schema name>.<package_name> compile; alter package <schema name>.<package_name> compile body; ...
select owner,object_name,object_type from dba_objects o where status = ‘INVALID’ and owner = ‘GZDQMP’ and o.OBJECT_TYPE=’VIEW’;解决是重新编译。 ORA-04065:未执行,已更改或删除stored procedureXXX(过程名) 错误说明:同一个过程中调用了多过程,先跑的过程中有DROP表后重建的操作,DROP表的操作...
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; ...
SQL>selectowner,object_name,object_typefromdba_objectswherestatus='INVALID';1.2、修正无效的对象编译对象SQL>alterprocedureADD_NUMScompile;Procedurealtered.如果编译成功,就不存在问题,如果编译失败,就需要找出失败的原因。SQL>showerrors如果希望确定编译错误的原因,通常需要首先使用DBA_DEPENDENCIES视图。SQL>descdba_...
ORA-12170:TNS:Connect timeout occurred，说明CPSETL.BI_FEED_CUSTOMER_SNAPSHOT里有远程dblink涉及，需要具体诊断该远程dblink访问问题。