DEFERED Problem in Materialized Views Creation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DEFERED Problem in Materialized Views Creation

  1. #1
    Join Date
    May 2003
    Posts
    32

    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
    Share on Google+

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width