OraFAQ Forum: Replication » users_snapshot vs. user

Home » Server Options » Replication » users_snapshot vs. user_refresh

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

users_snapshot vs. user_refresh [message #366517]

Mon, 27 March 2000 07:28

Juergen Schmidtlein
Messages: 1
Registered: March 2000

Junior Member

Hi,
i have some problems with using snapshots and getting informations about them.
I'm working under ORACLE-Version 7.3.4 and i found in different views (user_snapshot, user_refresh ) different data about the snapshots.
Which of them is the right view to get informations.

Thx

Juergen

Report message to a moderator

Re: users_snapshot vs. user_refresh [message #366518 is a reply to message #366517]

Mon, 27 March 2000 10:54

Cindy
Messages: 88
Registered: November 1999

Member

They are both good information about snapshots.
Whenever you create a snapshot, a refresh group
for that snapshot is automatically created.
USER_REFRESH shows information about the refresh
group for the snapshot, and USER_SNAPSHOTS shows
information about the snapshot itself.

Report message to a moderator

Previous Topic:	replicate user
Next Topic:	Best way to create crosstab materialized view

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 21:53:48 CDT 2024