Materialized Views in Oracle

[umesh049]

hi all

can any body tell me the why we use materialized views in

oracle

thanks
umesh

[dsr swamy]

hi this is ramaswamy and the answer is to get the physical data from existing tables....

[altafasa2]

Materialize view is actual object created in the Database based on the undelying select statement. Also it can be configured to referesh automatically based on specified time schedule.

[debasisdas]

The main purpose of creating materialized views is data replication.

[umesh049]

hello sir

i have also send one more question can u give answer of that question

thanks

[rameshrd]

Hi,
here i am giving details about materialized veiews advantage:

Each row in the materialized view can not be mapped back to a single row in a source table.

Materialized View :A materialized view is a database object that contains the results of a query. The FROM clause of the query can name tables, views, and other materialized views. Collectively these objects are called master tables (a replication term) or detail tables (a data warehousing term). This reference uses "master tables" for consistency. The databases containing the master tables are called the master databases.

When you create a materialized view, Oracle Database creates one internal table and at least one index, and may create one view, all in the schema of the materialized view. Oracle Database uses these objects to maintain the materialized view data. You must have the privileges necessary to create these objects.


Read this and let me know any query

Thanks
Ramesh

hi all

can any body tell me the why we use materialized views in

oracle

thanks
umesh