By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,454 Members | 1,804 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,454 IT Pros & Developers. It's quick & easy.

automatic refresh of materialized view does not work

P: n/a
Hie all,

I am currently using materialized views within Oracle 9i.

For instance I create mv1 on DB bddist2, as a snapshot of sur1 on bddist1 :

SQL> create materialized view mv1
2 refresh force
3 start with sysdate
4 next sysdate+1/(24*60)
5 as
6 select * from sur1@bddist1;

I manage to create the materialized view, refresh it manually using "dbms_snapshot.refresh",
but automatic refresh does not work (it never occurs).

I created a master site repadmin and a mat. view site mvadmin using the wizard.
I use a private DB link for my user.
I create the snapshot using this user's account.
JOB_QUEUE_PROCESSES is set to 10

Any idea ?

Thanks for help

Matthieu EXBRAYAT
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
To give some more details :
When my materialized view and master table are on the same database, it works fine.
The problem arises when they are on two different databases...

M. EXBRAYAT
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.