中心库建:
日志代码:
Drop SNAPSHOT LOG ON T_SB_XHK
/
CREATE SNAPSHOT LOG ON T_SB_XHK
WITH ROWID
INCLUDING NEW VALUES
分局库:
快速快照代码
DROP SNAPSHOT T_SB_XHK
/
CREATE SNAPSHOT T_SB_XHK
BUILD IMMEDIATE
REFRESH fast WITH ROWID
ON DEMAND FOR UPDATE
AS
SELECT * FROM T_SB_XHK@databaselink
其中databaselink正确,可查询到中心的数据
但建立fast快照时总报错:
ORA-23413: 表"myuser"."T_SB_XHK" 没有快照日志
但中心库中明明建立日志成功了……
请问谁知道有什么原因可能会这样吗?或者是不是版本的问题??
you may try as following step :-
1. conn sys
2. grant query read write to DBA(I forget, you need to refer guideline)
3. conn DBA
4. try to create snapshot again