Updatable Materialized View Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Updatable Materialized View Problem

  1. #1
    Join Date
    May 2003
    Posts
    32

    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 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

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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 09:42 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    May 2003
    Posts
    32
    I m working on Oracle 9i release 2.

    Thanks
    RAFF

  4. #4
    Join Date
    May 2003
    Posts
    32
    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

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