Snashot logs are created locally on the base. Not using db link. It should be created on the database that the base table resides.
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
If you reply to this email, your message will be added to the discussion below:http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/ SNAPSHOT-ERROR-tp1511.html To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML
| Free forum by Nabble |