Quote Originally Posted by areeb
Why is that dblink works not materialized view?
DBLink is just giving you connectivity, it touches nothing there.
Think of a DBLink just like a client session connecting to the target database.