Troubles creating materialized view
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.
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.
0