Cache a remote table?

Is it possible to a cache a remote table that is being accessed via a database link in the local db_cache?

We do not want to copy the table to the local database or create a local view on the remote table.

Quote:

---

Originally Posted by newbie5

Is it possible to a cache a remote table that is being accessed via a database link in the local db_cache?

---

no

Quote:

---

We do not want to copy the table to the local database or create a local view on the remote table.

---

Why not?

Sounds like the classic situation where a materialized view is used to me.

Cheers

Tim...