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...
--生成手动编译无效对象的脚本,然后执行脚本。SELECT'ALTER '||OBJECT_TYPE||' '||OWNER||'.'||OBJECT_NAME||' COMPILE;'FROMDBA_OBJECTSWHERESTATUS='INVALID'ANDOBJECT_TYPEIN('PACKAGE','PACKAGE BODY','FUNCTION','PROCEDURE','TRIGGER','VIEW','SYNONYM','JAVA SOURCE','JAVA CLASS'); 复制 utlrp.s...
ORA-04063:view “GZDQMP.V_VIEW_NAME” has errors或者package body ‘…’ has errors等等 错误说明:视图的状态为INVALID。select owner,object_name,object_type from dba_objects o where status = ‘INVALID’ and owner = ‘GZDQMP’ and o.OBJECT_TYPE=’VIEW’;解决是重新编译。 ORA-04065:未执行,已...
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; ...
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; ...
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访问问题。
U1@192.168.8.101/pdb1>create table t1 as select * from dba_objects; Table created. U1@192.168.8.101/pdb1>select count(*) from t1; COUNT(*) --- 72359 6)模拟应用侧停应用,将源端PDB置为read only SYS@ora19c>alter pluggable database pdb1 close immediate; Pluggable data...
杨志洪,dbaplus社群联合发起人,新炬网络首席布道师,对数据库、数据管理有深入研究,合译《Oracle核心技术》《Oracle Exadata专家手册》。 大规模升级来临,咱们来谈谈Oracle 12cR2使用经验。 一、升级到12cR2的必要性 随着2019年2月13日,Oracle 19c (Oracle 12.2.0.3) for Exadata 版本发布,Oracle 12cR2体系的数据库...