Skip to Main Content
Forums

Oracle Database Discussions

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 with fast refresh and CLOB

whitecatJan 20 2014 — edited Jan 28 2014

Folks,

I have a table named ABC in a database named D1. This table has a CLOB column named CLOBCOL.

I am trying to replicate ABC table in database D2 using dblink.

So, I tried to create Materialized View  ABCMV in database D2 using the dblink. But, cant create because of CLOB datatype.

So, thought of creating View first in database D1 and then create Materialized View in database D2.

But, the problem is, if I do so, then the materialized view cant be 'refresh fast' as it needs materialized view log. Now, since this Materialized View is supposed to be based on View in D1, where and how do I create materialized view log.

Please help.
This post has been answered by Richard Harrison . on Jan 22 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2014
Added on Jan 20 2014
#database, #general-database-discussions, #tuning
12 comments
6,070 views