Hi ,
i have the following errors :
ORA-12018: following error encountered during code generation for "MYSPACE"."RECORD"
ORA-00942: table or view does not exist
i was trying to create an mv as follows for fast refresh
-- this is on server A
create materialized view log on record
with rowid
including new values
-- this is on server B
create materialized view record
refresh fast on demand
next null
with rowid
as select * from myspace.record@dblink1
BUT when i changed it to force , then it could be created
pls advise
tks & rgds