Home » SQL & PL/SQL » SQL & PL/SQL » DBLINK and materialized views (Oracle 10g)
DBLINK and materialized views [message #315459] Mon, 21 April 2008 09:51 Go to next message
borafaq
Messages: 5
Registered: April 2008
Junior Member
Hi,
I have two databases A and B. I use dblink to connect A to B. A is the database on which my application is and B is the database I collect data from. But everytime the B database is broken or for some reason I cannot connect to B my application breaks.

Can someone suggest a way so that even if B breaks, my application doesnt break and atleast I can view the data even if its not the most updated one?

Thanks in advance.
Re: DBLINK and materialized views [message #315462 is a reply to message #315459] Mon, 21 April 2008 09:55 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The title of your post suggests that you know the answer already.

You can create 'On Commit' refreshing materialized views in Db A, each ov which is based on a single table in Db B
Re: DBLINK and materialized views [message #315466 is a reply to message #315462] Mon, 21 April 2008 10:14 Go to previous messageGo to next message
borafaq
Messages: 5
Registered: April 2008
Junior Member
yes. I thought the materialized view should work but for some reason I am not able to create a materialized view over the dblink. Any suggestions regarding that or is there any other alternate way?
Re: DBLINK and materialized views [message #315695 is a reply to message #315462] Tue, 22 April 2008 07:58 Go to previous messageGo to next message
borafaq
Messages: 5
Registered: April 2008
Junior Member
When I am trying to create a materialized view it gives me insufficient privileges error. Can you advise?
Re: DBLINK and materialized views [message #315706 is a reply to message #315695] Tue, 22 April 2008 08:44 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
What is the statement that you are executing, and the error that you are getting?
Previous Topic: NOT NULL check in function
Next Topic: Referential Integrity
Goto Forum:
  


Current Time: Wed Dec 07 14:31:35 CST 2016

Total time taken to generate the page: 0.19074 seconds