Toad World® Forums

browsing materialized wiews


#1

Hi,

I tried to use “browse data” and “quick browse” functions for Materialized View in SQL Navigator 5.5.0 and then 5.5.2 but unfortunately they did’t work.

There was no reaction for “browse data” and empty window for “quick browse” - without "select field1,…,fieldn from ".

Is it SQL Navigator problem or my installation problem?

Thanks in advance

zygmunt


#2

Hi,
Materialized view has corresponding table object, try use browse on table object.
When U create MV on schema , oracle creates table for MV.
But yes, i thing browse should work directly on MV object, it was logged a long time ago :wink:


#3

Thank you very much,

zygmunt