Hi again!
Just want to update you all.
Its working fine if i remove the DEFERRED keyword, and will create an updatable mv with the LOB column. But i have to use this DEFERRED keyword as i m working on a WAN environment and sont want to put the load in it while creating the MV's.

Thanks.

RAFF