OraFAQ Forum: Training & Certification » Materilized View (Clarification Required)

Home » Other » Training & Certification » Materilized View (Clarification Required) (oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Materilized View (Clarification Required) [message #357966]

Fri, 07 November 2008 07:27

kmkan28
Messages: 14
Registered: December 2005

Junior Member

Hi,
Materialized views are the snashots of remote database.Can any one Please explain what will happen when the remote DB's Materialized view is dropped?.

Report message to a moderator

Re: Materilized View (Clarification Required) [message #357969 is a reply to message #357966]

Fri, 07 November 2008 07:35

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It won't exist any more.

I *know* this isn't the answer you are looking for, but - I just didn't understand the question. Materialized view contains data (unlike an "ordinary" view). So, if you drop a table which was used while creating materialized view, nothing will happen (until materialized view gets refreshed).

So, what do you mean by dropping "remote DB's materialized view"? What is a "remote DB's materialized view"? Why do you care about it? How do you access it? Do you access it?

Could you explain it a little bit more?

Report message to a moderator

Re: Materilized View (Clarification Required) [message #357970 is a reply to message #357969]

Fri, 07 November 2008 07:47

kmkan28
Messages: 14
Registered: December 2005

Junior Member

Hi
Thank you for immediate reply.This is the question asked to me during an interview.I havent created and used any mat.view.

The question is

Materialized views are created using Remote Database's tables or views.If any of the Table or views dropped at the remote server,what will happen when we call the Materialized view from the client side?.

For the above the question only i am looking for answer.

Report message to a moderator

Re: Materilized View (Clarification Required) [message #358017 is a reply to message #357970]

Fri, 07 November 2008 14:36

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If that's so, I expect nothing will happen; as previously has been said, a materialized view contains data so - if you don't refresh it, it will work just perfectly, regardless the fact someone has dropped a table in a remote database.

Report message to a moderator

Previous Topic:	OCA Exam - Nov. 25?
Next Topic:	Oracle Architecture

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 09 00:18:16 CST 2026