Home » Other » Training & Certification » Snapshots with referential Integrity
icon5.gif  Snapshots with referential Integrity [message #254205] Thu, 26 July 2007 02:50 Go to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member
Hello,

Can anybody give answers to my below questions?

1. How can you Enforce Referential Integrity in snapshots?

2. What are the options available to refresh snapshots?

3. When will the data in the snapshot log be used?

4. What are lex parameters?

5. Advantage of using library over database functions?

Thanks in advance,
Prachi
Re: Snapshots with referential Integrity [message #254219 is a reply to message #254205] Thu, 26 July 2007 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do YOU think?

Regards
Michel
Re: Snapshots with referential Integrity [message #254543 is a reply to message #254219] Fri, 27 July 2007 01:37 Go to previous messageGo to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member
May be by creating Complex Snapshots.
Re: Snapshots with referential Integrity [message #254544 is a reply to message #254543] Fri, 27 July 2007 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is the anwser of which question?

Regards
Michel
Re: Snapshots with referential Integrity [message #254546 is a reply to message #254544] Fri, 27 July 2007 01:44 Go to previous messageGo to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member
I am sorry, the first one.
Will let u know about others slowly, but of the last 2 I don't know.

Thanks.
Re: Snapshots with referential Integrity [message #254576 is a reply to message #254546] Fri, 27 July 2007 03:05 Go to previous messageGo to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member
Am I right?

Thanks in advance.
Prachi
Re: Snapshots with referential Integrity [message #254588 is a reply to message #254576] Fri, 27 July 2007 04:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Question is not clear and can be read in several ways.

Regards
Michel
Re: Snapshots with referential Integrity [message #254691 is a reply to message #254588] Fri, 27 July 2007 09:46 Go to previous messageGo to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member
Hi,

What you have not got? The questions?
If so, I have asked 5 questions?

And I answered for the first one.

Is that clear now?
If not, pls let me know what you didn't get?

Thanks in advance,

Prachi
Re: Snapshots with referential Integrity [message #254712 is a reply to message #254691] Fri, 27 July 2007 11:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I meant first question (the one you answer) is not clear.
Quote:
1. How can you Enforce Referential Integrity in snapshots?

Does this means:
- can we add a referential integrity to a snapshot?
- referential integrity between 2 snapshots or a snapshot and a table?
- in the latter, which one is the parent and which one the child?
- when enforcing referential integrity during refresh or out of refreshing time?
- ...

Regards
Michel
Re: Snapshots with referential Integrity [message #254776 is a reply to message #254712] Sat, 28 July 2007 01:37 Go to previous messageGo to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member
Embarassed
Sir,

Thanks for the reply.
I really do not know more about snapshots. This question I read in some document & not found the answer. So put this on Ora-faq.

What I know is Snapshot is somewhat similar to view which you can use for Remote Databases.
I really don't know that it has Referential Integrity COncept attached with it.

So, I put this request.

Thanks in advance,
Prachi G.
Re: Snapshots with referential Integrity [message #254777 is a reply to message #254776] Sat, 28 July 2007 02:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Snapshot is now named "materialized view" and its name is quite explicit.
It is like a view but with result stores in a table of the database.
It is refreshed with the condition you give (periodically, on demand, on commit).

If your book talks about snapshot without speaking of materialized view then it is out of date from 10 years.
Through it away and read Oracle documentation.

Regards
Michel

Re: Snapshots with referential Integrity [message #254778 is a reply to message #254777] Sat, 28 July 2007 02:28 Go to previous messageGo to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member
Sir,

Thanks for your reply.
Yes I know it's now called as Materialized views. Sorry I named it wrongly.

If you have time, can you provide me the latest documentation on it OR can you tell me from where will I get it?

Regards,
Prachi G.
Re: Snapshots with referential Integrity [message #254779 is a reply to message #254778] Sat, 28 July 2007 03:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/search?remark=quick_search&word=materialized+view&tab_id=&format=ranked

Regards
Michel
Re: Snapshots with referential Integrity [message #254780 is a reply to message #254779] Sat, 28 July 2007 03:27 Go to previous message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member

Thanks Sir.

Prachi
Previous Topic: plz help me out with this query
Next Topic: 8 Questions req. clarification for funda II exam
Goto Forum:
  


Current Time: Sun Dec 11 04:39:49 CST 2016

Total time taken to generate the page: 0.11752 seconds