SELECT owner, object_name, object_type,status 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...
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...
SQL> SELECT OBJECT_NAME, OBJECT_TYPE, OWNER, CREATED, LAST_DDL_TIME, TIMESTAMP FROM dba_objects WHERE status = 'INVALID' AND object_name NOT LIKE 'BIN$%' AND object_type NOT IN ('MATERIALIZED VIEW'); 产生无效对象数原因:导数据或者编译程序 处理办法: 办法1:逐个恢复 查看view对象 SQL> sel...
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; 1. 或者 [oracle@db01 ~]$ sqlplus / as sysd...
--编译所有无效PROCEDURE对象BEGIN FOR cur IN ( SELECT object_name ,object_type FROM dba_objects WHERE object_type = 'PROCEDURE' AND status = 'INVALID' ) LOOP DBMS_OUTPUT.PUT_LINE(cur.object_name); EXECUTE IMMEDIATE 'ALTER ' || cur.object_type || ' ' || cur.object_name || ' COMPILE...
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; ...
FROM USER_OBJECTS WHERE STATUS='INVALID'; 1. 2. 3. utlrp.sql脚本 执行@$ORACLE_HOME/rdbms/admin/utlrp.sql脚本编译数据库失效对象。 数据库的升级迁移等操作可能会导致数据库中大量对象失效,由于对象间可能存在复杂的依赖关系,手工编译通常无法顺利通过。Oracle强烈建议在升级迁移后,运行此脚本编译失效对象。utl...
HKJJW TEST VIEW 2013-08-02 2013-08-02 INVALID 指定查询某用户无效对象。 SQL> select * from dba_objects where status<>'VALID' and owner='HKJJW'; 2. 手动执行编译或 ALTER FUNCTION HKJJW.FUNC_RETURN_PY COMPILE; ALTER VIEW HKJJW.MONITORING_FLOW_PARALLEL_VIEW COMPILE; ...
from dba_objects t where status='INVALID' and t.object_type='FUNCTION' order by t.owner,t....
Oracle_database_component_statusOracle Database Component StatusOracle Database DBA Registry Component Status. Below are the possible values: INVALID - 0 VALID - 1 LOADING - 2 LOADED - 3 UPGRADING - 4 UPGRADED - 5 DOWNGRADING - 6 DOWNGRADED - 7 ...