Mview creation PLS-00352: Unable to access another database 'PASS.COM'
I'm trying to fast refresh a mview in 12c , the source is 9i
From 9i , I have connected to intermediate db to 10g, I'm able to fast refresh the mview in 10g.
I'm trying to fast refresh mview in 12c, pointing to the one in 10g.
CREATE MATERIALIZED VIEW TAPER.SUMM
TABLESPACE SRO_DATA_T01
PCTUSED 0
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 80K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
BUILD IMMEDIATE
USING INDEX
TABLESPACE SRO_DATA_T01
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
REFRESH FAST
START WITH TO_DATE('17-07-2016 02:48:00','dd-mm-yyyy hh24:mi:ss')