Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Difference between synonym and materialized view
I need to have access(update, delete, insert, select) to a remote
table through a database link. I am wondering should I create a
synonym or materialized view(snapshot)?
If I create a local synonym through database link to the remote account which owns the tables, I will get all the permission which is very straight forward. Is there any reason to use a materialized view if I need access for the entire table, not part of table?
Thanks,
ewong
Received on Mon Oct 01 2001 - 12:31:32 CDT
![]() |
![]() |