|
-
Here is an example of how you should do it:
MASTER site:
CREATE SNAPSHOT LOG ON TABLE_NAME
TABLESPACE REPLICA
PCTFREE 60 PCTUSED 30 MAXTRANS 255
STORAGE (INITIAL 1024K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0)
WITH ROWID
EXCLUDING NEW VALUES;
SNAPSHOT SITE:
CREATE SNAPSHOT TABLE_NAME
PCTFREE 10 PCTUSED 40 MAXTRANS 255
STORAGE (INITIAL 1024K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
TABLESPACE ADS_DATA
BUILD IMMEDIATE
USING INDEX TABLESPACE ADS_INDX
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 1024K NEXT 1024K PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 2147483645
FREELISTS 1 FREELIST GROUPS 1 )
REFRESH FORCE WITH ROWID
START WITH sysdate
NEXT sysdate + (1/1440)
AS
SELECT * FROM INSTRU@MASTER;
This works for me. 1/1440 is 1 minute. All the date gets replicated every minute.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|