-
DEFERED Problem in Materialized Views Creation
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.
I m working on Oracle 9i release 2.
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 dont want to put the load in it while creating the MV's.
How am i going to create an updatable mv base on the table containing LOB columns.
Suggesstions.
RAFF
-
Why do you keep asking the same question angain and again, with different Subject header.
I think MH has answered your question. Read your previous threads. If not satisfied with the answers then contact Oracle Support. Closing duplicate threads.
http://www.dbasupport.com/forums/sho...threadid=36918
http://www.dbasupport.com/forums/sho...threadid=36909
Amar
"There is a difference between knowing the path and walking the path."
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|