Database DataWarehousing (MOSC)

MOSC Banner

Troubles creating materialized view

edited Jan 14, 2010 1:29AM in Database DataWarehousing (MOSC) 5 commentsAnswered
 I am chasing down a mystery of why I cannot create a materialized view on this one particular table in my database.
I've simplified it down to this ...

drop materialized view log on seis_line;
create materialized view log on seis_line with primary key, rowid;

drop materialized view marktest_mv;
create materialized view marktest_mv
refresh fast on commit
as
 select rowid, seis_line_id, seis_set_type, k_owner_ba
 from seis_line;

End result... ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

The table DOES have an RLS policy.  I adjusted the RLS policy to return a NULL in order to get around the materialized view create problem (the RLS security function knows if its the owner accessing the table - if it detects that it returns a NULL return clause).  I dropped the policy just to be sure and I still cannot create the MV - same error as before.

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