Updatable Materialized View Problem

[RAFF]

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 xyz@ORACLE.Net

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

[adewri]

Oracle Version ??

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

Refer to Metalink Note 119897.1

[RAFF]

I m working on Oracle 9i release 2.

Thanks
RAFF

[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