Re: materialized view. help...
From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 25 Aug 2003 12:38:32 -0700
Message-ID: <3722db.0308251138.576116f3_at_posting.google.com>
Date: 25 Aug 2003 12:38:32 -0700
Message-ID: <3722db.0308251138.576116f3_at_posting.google.com>
According to what I see in the Data Warehouse manual (http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/mv.htm#721), inline views (i.e. what you try) is only possible in the FROM clause of the MV definition, and not in the SELECT clause, as you are trying.
Daniel Received on Mon Aug 25 2003 - 21:38:32 CEST