Home » SQL & PL/SQL » SQL & PL/SQL » Materialized View
Materialized View [message #223750] Sat, 10 March 2007 23:29 Go to next message
Messages: 235
Registered: July 2006
Location: INDIA
Senior Member

Where are Materialized stored arter creation,please guide me
Re: Materialized View [message #223775 is a reply to message #223750] Sun, 11 March 2007 05:36 Go to previous message
Messages: 21127
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Materialized views contain results of a query (which differs them from ordinary views which do not contain data nor require storage space). Physically, they are stored in the datafile on the disk. Logically, in a tablespace, in owner's schema. They might be stored in a database which contains materialized view's base table(s), or in a different database (n that case, you'll need to use a database link).

As it is yet another question you've asked about materialized views, perhaps it would be a good idea to visit Oracle Documentation page and read more about MV concept and any other thing you'd like to know about them.
Previous Topic: matrialized
Next Topic: Tabel creation Money?
Goto Forum:

Current Time: Fri Jul 21 14:08:22 CDT 2017

Total time taken to generate the page: 0.13749 seconds