Home » Server Options » Replication » users_snapshot vs. user_refresh
users_snapshot vs. user_refresh [message #366517] Mon, 27 March 2000 07:28 Go to next message
Juergen Schmidtlein
Messages: 1
Registered: March 2000
Junior Member
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.


Re: users_snapshot vs. user_refresh [message #366518 is a reply to message #366517] Mon, 27 March 2000 10:54 Go to previous message
Messages: 88
Registered: November 1999
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.
Previous Topic: replicate user
Next Topic: Best way to create crosstab materialized view
Goto Forum:

Current Time: Sat May 21 13:54:59 CDT 2022