DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Accessing LOB data type remotely using dblink

  1. #1
    Join Date
    May 2001
    Location
    Boston
    Posts
    24

    Accessing LOB data type remotely using dblink

    HI,

    I am trying to connect to a remote table which has got CLOB columns
    and create it locally using dblink.

    When i try to do that i get the following error
    ORA-22992 cannot use LOB locator selected from remote table.

    Any workaround would be appreciated.

    --RaviShankar.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: Accessing LOB data type remotely using dblink

    Originally posted by GRAVIS
    HI,

    I am trying to connect to a remote table which has got CLOB columns
    and create it locally using dblink.

    When i try to do that i get the following error
    ORA-22992 cannot use LOB locator selected from remote table.

    Any workaround would be appreciated.
    I'm not aware of any fancy workaround for that. What you could do is to create snapshots for those tables in your local database and propagate those remote LOBs data by refreshing snapshots.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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