Updatable Materialized View Problem
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
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.
Oracle Version ??
Below 8.1.6, select of LOB across dblinks is not supported.
Refer to Metalink Note 119897.1
Last edited by adewri; 06-17-2003 at 08:42 AM.
"There is a difference between knowing the path and walking the path."
I m working on Oracle 9i release 2.
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.
Click Here to Expand Forum to Full Width