记录一次通过dblink访问adg出异常处理过程
数据库架构历史库通过dblink到ADG查询数据库，发现ORA-04045错误sys@q9db1> SELECT ID, 'GE_BILL_PRINT_HISTORY'
2 FROM USR_DML.GE_BILL_PRINT_HISTORY@TOQ9ADG
3 WHERE PRINT_DATE >=
4 TO_DATE('2013-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
5 AND PRINT_DATE <
6 TO_DATE('2013-01-31 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
7;
FROM USR_DML.GE_BILL_PRINT_HISTORY@TOQ9ADG
*
ERROR at line 2:
ORA-04045: errors during recompilation/revalidation of USR_DML.GE_BILL_PRINT_HISTORY
ORA-16000: database open for read-only access
ORA-02063: preceding 2 lines from TOQ9ADG
adg库查询相关同义词
10:25:34 sys@Q9DB>select owner,object_type ,STATUS
10:25:41 2from dba_objects where object_name='GE_BILL_PRINT_HISTORY' and owner='USR_DML';
OWNER OBJECT_TYPE STATUS
------------------------------ ------------------- -------
USR_DML SYNONYM INVALID
主库上重新编译同义词
alter synonym USR_DML.GE_BILL_PRINT_HISTORY compile;
:D 好像刚才看到这个问题了
页:
[1]