9 Replies Latest reply on May 28, 2015 2:56 PM by Steven Hawkins

    Cache a view without materialization ...

    Ki Alam Newbie

      I'm using dynamic VDBs, and I was wondering if there was a way to cache the view's data.  From the docs it looks like materialization isn't available for dynamic VDBs, so I tried to do:

       

        CREATE VIEW attributes (

                                      attribute varChar(100) NOT NULL,

                                      src varchar(4000) NOT NULL

                              ) AS

                                      /*+ cache(ttl:3600000) */ select attribute, src from master where src like 'b1x551%';

       

      It doesn't appear to have taken.  Any other tricks on how I could induce caching with a dynamic vdb?

       

      Thanks,

      Ki