Materialized View with ROWID
Hi,
As per Oracle 10g doc, Mat View WITH ROWID must be based on a single table and cannot contain any of the following:
* Distinct or aggregate functions
* GROUP BY or CONNECT BY clauses
* Subqueries
* Joins
* Set operations
Rowid materialized views are not eligible for fast refresh after a master table reorganization until a complete refresh has been performed.
I have created a sample table with a PK on ID column.
create table sample as select rownum as id, owner,object_name , object_type from all_objects;
CREATE INDEX ind ON sample(ID);
alter table sample add constraint PK_ID primary key(ID);
As per Oracle 10g doc, Mat View WITH ROWID must be based on a single table and cannot contain any of the following:
* Distinct or aggregate functions
* GROUP BY or CONNECT BY clauses
* Subqueries
* Joins
* Set operations
Rowid materialized views are not eligible for fast refresh after a master table reorganization until a complete refresh has been performed.
I have created a sample table with a PK on ID column.
create table sample as select rownum as id, owner,object_name , object_type from all_objects;
CREATE INDEX ind ON sample(ID);
alter table sample add constraint PK_ID primary key(ID);
0