创建用户供备库查询和ORA-04045 ORA-16000 背景和目的: 为不影响主库性能,创建一用户和视图只允许在备库访问。涉及视图中表较大,结构设计不合理,性能稍差。 过程: 创建视图、用户、授权、创建同义词、验证 1、produser 用户创建视图 切换到g_tab等用户下 alter session set current_schema = produser; 替换下面...
we are using active dataguard for reporting purpose and getting ORA-04045 intermittently,on checking primary database which is production there are no invalid objects in application schema nor any DDL operation was being performed on any objects. Surprising, we are getting the error when querying t...
ORA-04045是Oracle数据库中的一个常见错误,具体信息为"errors during recompilation/revalidation of "。此错误表明在尝试重新编译或重新验证数据库对象(如表、视图、包、过程、函数等)时遇到了问题,导致该对象无法被正确编译或验证。 可能导致ORA-04045错误的原因 对象损坏:数据库对象可能因为各种原因(如硬件故障、不...
ORA-04045: 在重新编译/重新验证 V_TEST_JOIN 时出错 ORA-16000: 数据库或可插入数据库是以只读访问方式打开的 1. 2. 3. 4. 二、 报错原因及处理方法 1. 报错原因 视图V_TEST_JOIN失效,在select时会自动编译,但访问的是从库,而从库是只读的,因此编译会报错ORA-16000: 数据库或可插入数据库是以只读访...
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]: ORA-04045 and ORA-16000 on when Recompiling on a Data Guard Standby Open in Read-
记一次oracle视图查询失效的情况,ERROR at line 1: ORA-04045: errors during recompilation/revalidation of NC633.BB_API_BUDGET_EXEINFO ORA-16000: database open for read-only access 背景:oracle主库和dg库,在dg库上只读。发现查询有报错。2、查询失效的视图数量;SQL...
ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS,使用orachk工具检查数据库实例的时候,发现报告里面有类似下面这`
该问题昨晚已解决，附上问题解决记录：https://www.cnblogs.com/silgen/p/16694486.html ...
Oracle Database - Enterprise Edition - Version 11.2.0.0 to 19.11.0.0.0 [Release 11.2 to 19]: Database Upgrade Failed Due to ORA-04045: errors during recompilation/re
如下所示,LBACSYS下有很多INVALID对象,最奇怪的是,执行了上面脚本,会触发ORA-04045,似乎还会导致其他会话执行脚本时也触发这个错误: SQL> col comp_namefora36; SQL> col versionfora30; SQL> col versionfora10; col statusfora8; selectcomp_id, comp_name, version, status ...