创建用户供备库查询和ORA-04045 ORA-16000 背景和目的: 为不影响主库性能,创建一用户和视图只允许在备库访问。涉及视图中表较大,结构设计不合理,性能稍差。 过程: 创建视图、用户、授权、创建同义词、验证 1、produser 用户创建视图 切换到g_tab等用户下 alter session set current_schema = produser; 替换下面...
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-
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...
背景:oracle主库和dg库,在dg库上只读。发现查询有报错。 2、查询失效的视图数量; SQL> SELECT COUNT(1) FROM DBA_OBJECTS WHERE STATUS='INVALID'; 3、在主库上面重新编译所有视图即可。 SQL> @utl
ORA-04045: errors during recompilation/revalidation of ORA-16000: database open for read-only acces Hi Gurus, 11203 Primary RAC 11203 Standby RAC(ADG) we are using active dataguard for reporting purpose and getting ORA-04045 intermittently,on checking primary database which is production there ...