Database links

[julian]

Pras: Replace below THE_NAME_OF_THE_TABLESPACE with the real name you use.

On the master site run this:

CREATE SNAPSHOT LOG ON EMP
TABLESPACE THE_NAME_OF_YOUR_TABLESPACE
PCTFREE 60 PCTUSED 30 MAXTRANS 255 
STORAGE (INITIAL 1024K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0)
WITH PRIMARY KEY, ROWID
INCLUDING NEW VALUES;

In the snapshot site run:

CREATE SNAPSHOT EMP_MV
PCTFREE 10 PCTUSED 40 MAXTRANS 255 
STORAGE (INITIAL 1024K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645 
         PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
TABLESPACE THE_NAME_OF_THE_TABLESPACE
BUILD IMMEDIATE 
USING INDEX TABLESPACE THE_NAME_OF_THE_TABLESPACE
PCTFREE 10 INITRANS 2 MAXTRANS 255 
STORAGE(INITIAL 256K NEXT 256K PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 2147483645 
        FREELISTS 1 FREELIST GROUPS 1 )
REFRESH FAST WITH PRIMARY KEY
START WITH trunc(sysdate) + 4/24
NEXT trunc(sysdate+1) + 4/24
AS
SELECT * FROM VEROKUNTA@AM;

Your MV will be refreshed every morning at 4AM.

[pras]

Hi Julian,

Sorry my mistake...the only prob was i was giving the name of the db link in lower case..It should be in upper case..now i am able to create the materialized view also..Thanks again

Good day..
pras

[pras]

Hi Julian,

Thanks for the code...U made my day..

pras