Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Question about materialized views/snapshots
Is there are a way to have the snapshot contain 'stale' data while it's refreshing? We have joins w/ snapshots, and whenever they're refreshing the joins return nothing.
The alternatives are outer joins and replacing a snapshot w/ a table which would be populated and deleted from in a single transaction.
Thanks.
.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes
remove NSPAM to email
Received on Thu Jun 10 2004 - 14:06:20 CDT
![]() |
![]() |