Updatable Materialized View Problem

Hi .
I want to create a updatable materialized view with the DEFERRED option. In other words just want to create a mv and dont want the DATA of the base table to be filled in at creation of this mv.
It returns me back with the following error.
"ORA-22992: cannot use LOB locators selected from remote tables"

Here is my code
CREATE MATERIALIZED VIEW xyz_mv
BUILD DEFERRED
REFRESH FORCE
for update
AS SELECT * FROM [email protected]

My xyz table contains a column of the LOB data type.

How am i going to create an updatable mv base on the table containing LOB columns.


Suggesstions.

RAFF

Oracle Version ??

Below 8.1.6, select of LOB across dblinks is not supported.

Refer to Metalink Note 119897.1

I m working on Oracle 9i release 2.

Thanks
RAFF

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