Hi,

I would like to know about two situations:

1)my base table is not partitioned and i have a materialized view on the same. Is it possible to partition the materialized view.
If yes kindly provide steps for the same.

2)I have a table which has 6 hash partitions based on a key column.Now i want to create a materialized view on the same , which i also want to make hash partitioned.Kindly let me know about the steps how the same can be achieved.

Regards
Shibaji

Thanks & Regards

SQL> create table t as select * from dba_objects;

Table created.

SQL>
SQL> create materialized view MV
  2   partition by hash ( object_id )
  3   partitions 6
  4   refresh complete on demand
  5   as select * from t;

Materialized view created.