Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467

    Unanswered: Clob, Materialized Views, and DB links

    DB is 9.2

    I have a materialized view that "looks" like it is selecting a CLOB from a DB link and is not getting an error. Do materialized views not have the restriction with CLOBs over links that others have? Am I just missing something when I look at my MV?

    Thanks,
    Todd
    NOTE: Please disregard the label "Senior Member".

  2. #2
    Join Date
    Apr 2006
    Posts
    2
    All parameters for a replicated procedure must be IN parameters; OUT and IN/OUT modes are not supported. The following datatypes are supported for these parameters:

    * VARCHAR2
    * NVARCHAR2
    * NUMBER
    * DATE
    * RAW
    * ROWID
    * CHAR
    * NCHAR
    * Binary LOB (BLOB)
    * Character LOB (CLOB)
    * National character LOB (NCLOB)
    * User-defined datatypes

    Source:
    http://download-west.oracle.com/docs...anma.htm#22552

  3. #3
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    DA,

    I do not get the connection between your reply and my question. Considering that I may be exceedingly dense (I am not kidding) please expand upon how you answered my question.
    NOTE: Please disregard the label "Senior Member".

  4. #4
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Todd Barkus, care to post the view definition and its base tables please ? I can reproduce it, but not with a REFRESH ON COMMIT.

    DA Morgan, what that has to do with the original question ?

  5. #5
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    J,

    Pulling a CLOB over a link which is forbidden for mere mortals does not appear to be forbidden for Materialized Views. I was able to get enough priviliges to test that. I did not test with fast refresh (not the on commit type). I should do that.

    My question was more a cry for a sanity check. I guess I should have said as much.

    The table/materialized view definition is immaterial (no pun originally intended). It is just the ability to do what we have proven.

    Thanks,
    Todd
    NOTE: Please disregard the label "Senior Member".

  6. #6
    Join Date
    Apr 2006
    Posts
    2
    Sorry if my point wasn't clear. If Replication can do it then it is permitted.

Posting Permissions

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