Hi to all,
I'm trying to create a MV from two remote tables (via DBlink).
On the remote tables I have created the snapshot logs (PK).
The MV joins the tables using the PK (the join is simple).
If I create the MV whith fast refresh I get the error
ORA-12015: (see error below)
If I create with FORCE, then when I try to FAST refresh I get
ORA-12004: REFRESH FAST cannot be used for snapshot
whilst the Complete refresh works well.
Another thing,
if I create the master tables and the MV on the same schema,
the fast refresh works!
Maybe it's not possible to do this thing via DBlink?
I could't find any suggestion on this problem.
Thank to all