In my Freesql-session, db-version 19, the tables t_a, and t_c exist.
Materialized log views on these tables are created:
create materialized view log on t_a with primary key, rowid, sequence, commit scn (a_p) including new values;
create materialized view log on t_c with primary key, rowid, sequence, commit scn (c_p) including new values;
But then the next statement fails:
create materialized
view t_mv_a_l_c
refresh fast
on commit
as
select a.a_k
, a.a_p
, c.c_k
, c.c_p
--
, cast(
a.a_k
|| c.c_k
as varchar2(10)
) as pk_a_l_c
--
, c.a_k as mvk_a_a_k
--
, a.rowid as mvr_a
, c.rowid as mvr_c
from t_a a
, t_c c
where 1 = 1
and a.a_k = c.a_k(+)
;
SQL> create materialized
view t_mv_a_l_c
refresh fast
on commit…
Show more…
ORA-01031: insufficient privileges
https://docs.oracle.com/error-help/db/ora-01031/
Error at Line: 4 Column: 0
Normally this would be solved by granting priviliges. But how is this done in Freesql?
(I tried the grant myself, but, of course, ORA-01031: insufficient privileges.)