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: 2108
Registered: October 2003
Location: Hyderabad, India
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: normal view and force view
Next Topic: Return a ref cursor for a PL/SQL table
Goto Forum:

Current Time: Wed Aug 23 14:37:10 CDT 2017

Total time taken to generate the page: 0.11916 seconds