SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Materialized view remote db fast refresh on commit

ronald_2017Oct 19 2016 — edited Oct 25 2016

Hi All,

When I create the following I get ORA-12054 error. What do you suggest?

create materialized view mv_table

build immediate

refresh fast on commit

with rowid

select * from my_table@remotedb;

Thanks in advance

This post has been answered by Jarkko Turpeinen on Oct 19 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 22 2016

Added on Oct 19 2016

11 comments

1,026 views