how is create matieralized view?

[priyasp_msit]

i craeted sqlplus but this did not accepted.

do u create only datawarehouing tool in materialized view ?
can u give example

[krishnaindia2007]

>>i craeted sqlplus but this did not accepted.

You can create materialized view from SQL * PLUS as follows

SQL> CREATE MATERIALIZED VIEW mv_emp
2 AS SELECT * FROM EMP;

Snapshot created.


What is the error message you getting?

[priyasp_msit]

SQL> CREATE MATERIALIZED VIEW mv_emp
2 AS SELECT * FROM EMP;
*
error is coming
missing identifier

[krishnaindia2007]

It seems you have pasted line number also

sql> create materialized view mv_emp
2 2 as select * from emp;
2 as select * from emp
* error at line 2: ora-00905: missing keyword

Just type it as follows
create materialized view mv_emp as select * from emp;

[priyasp_msit]

how is difference view and materialized view?
when do u use oracle datawarehousing?
what is impartent datawarehousing?

[krishnaindia2007]

>>Difference between view and materialized view?

-A view is a logical table based on a table or another view.
-A view contain no data of its own but it is like a window through which data from tables can be viewed or changed.
-The view is stored as a query in the data dictionary.

-Materialized view store the results of the query in the database.
-After the update, the view data matches the table data but the materialized view data does not.
-Data in materialized views must be refreshed to keep it synchronized with its base table.

[krishnaindia2007]

>>what is datawarehouse and what is its importance?

A data warehouse is a separate database dedicated to decision support. Data is transferred in from transaction processing (oltp) systems. It is accessed to provide management information through report writers, query tools, data access and retrieval tools, olap servers and enterprise information systems. A data warehouse is a software architecture, not a product.