Database Administration (MOSC)

MOSC Banner

Materialized View with ROWID

edited Dec 13, 2011 7:49PM in Database Administration (MOSC) 4 commentsAnswered
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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center