SNAPSHOT ERROR

Posted by Arsalan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/SNAPSHOT-ERROR-tp1511.html


Sir

question  (1) should i create snapshot or meterailazed view for data warehouse which one is more uesful ?

problem in snapshot


I want to create snapshot from remote db

1-create database link dwsig_link connect to "sigtasad" identified by "sigtas" using 'dwsig';

2-SQL> create snapshot log on ACCT_REPORT;
create snapshot log on ACCT_REPORT
*
ERROR at line 1:
ORA-00942: table or view does not exist

then i give link of db then it give other error


SQL> create snapshot log on sigtasad.ACCT_REPORT@dwsig_link;
create snapshot log on sigtasad.ACCT_REPORT@dwsig_link
                                           *
ERROR at line 1:
ORA-00949: illegal reference to remote database
----------------------------------------------------------------------------

if write select * from sigtasad.acct_report@dwsig_link;

it show record without error so the link is fine