create materialized view PR.YEAR
nologging
refresh fast
as select * from PR.YEAR@primary;

which gives,
ORA-01031: insufficient privileges


Create MV時,除了view中要有相關的table select的權限外,
必須要有以下的權限:

GRANT CREATE SESSION;
GRANT CREATE TABLE;
GRANT CREATE MATERIALIZED VIEW;
GRANT QUERY REWRITE; - if using query rewrite
arrow
arrow
    全站熱搜

    噗噗噗的潛水珽 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄