OraFAQ Forum: Training & Certification » Snapshots with referential Integrity

Home » Other » Training & Certification » Snapshots with referential Integrity

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

Snapshots with referential Integrity [message #254205]

Thu, 26 July 2007 02:50

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

Report message to a moderator

Re: Snapshots with referential Integrity [message #254219 is a reply to message #254205]

Thu, 26 July 2007 03:36

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What do YOU think?

Regards
Michel

Report message to a moderator

Re: Snapshots with referential Integrity [message #254543 is a reply to message #254219]

Fri, 27 July 2007 01:37

prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune

Member

May be by creating Complex Snapshots.

Report message to a moderator

Re: Snapshots with referential Integrity [message #254544 is a reply to message #254543]

Fri, 27 July 2007 01:40

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is the anwser of which question?

Regards
Michel

Report message to a moderator

Re: Snapshots with referential Integrity [message #254546 is a reply to message #254544]

Fri, 27 July 2007 01:44

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.

Report message to a moderator

Re: Snapshots with referential Integrity [message #254576 is a reply to message #254546]

Fri, 27 July 2007 03:05

prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune

Member

Am I right?

Thanks in advance.
Prachi

Report message to a moderator

Re: Snapshots with referential Integrity [message #254588 is a reply to message #254576]

Fri, 27 July 2007 04:07

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Question is not clear and can be read in several ways.

Regards
Michel

Report message to a moderator

Re: Snapshots with referential Integrity [message #254691 is a reply to message #254588]

Fri, 27 July 2007 09:46

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

Report message to a moderator

Re: Snapshots with referential Integrity [message #254712 is a reply to message #254691]

Fri, 27 July 2007 11:43

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Snapshots with referential Integrity [message #254776 is a reply to message #254712]

Sat, 28 July 2007 01:37

prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune

Member

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.

Report message to a moderator

Re: Snapshots with referential Integrity [message #254777 is a reply to message #254776]

Sat, 28 July 2007 02:05

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Snapshots with referential Integrity [message #254778 is a reply to message #254777]

Sat, 28 July 2007 02:28

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.

Report message to a moderator