DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Cache a remote table?

  1. #1
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178

    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.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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

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

  3. #3
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Sounds like the classic situation where a materialized view is used to me.

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width