Home » SQL & PL/SQL » SQL & PL/SQL » Creation of materialized view
icon6.gif  Creation of materialized view [message #217403] Fri, 02 February 2007 01:21 Go to next message
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member

I need to create a materialized view based on other master tablewhich contains some data. I need to create materialized view with only structure not with data. upon refersh of materialized view it has to be synch with master table.

CREATE MATERIALIZED VIEW SAM AS select scenario_id, item_id, description from MST_ITEM where 1=2 ;

But upon refreshing I am unable to see any data.

Thanks in advance

[Updated on: Fri, 02 February 2007 01:23]

Report message to a moderator

Re: Creation of materialized view [message #217419 is a reply to message #217403] Fri, 02 February 2007 01:58 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
While refreshing also it used same sql to populate.


[Updated on: Fri, 02 February 2007 02:00]

Report message to a moderator

Previous Topic: External Tables
Next Topic: normal view and force view
Goto Forum:

Current Time: Thu Apr 27 08:28:38 CDT 2017

Total time taken to generate the page: 0.04940 seconds