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
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member
HI,

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
Hi,
While refreshing also it used same sql to populate.
Check for BUILD DEFERRED

By
Vamsi

[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: Sat Dec 10 03:24:12 CST 2016

Total time taken to generate the page: 0.09454 seconds