Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2001
    Posts
    40

    Unanswered: Oracle replication and long/blob datatypes

    A very general but hopfully a simple question.

    Our company's schema has a few tables that have columns of datatypes LONG and BLOB. A customer of ours is complaining that they cannot run Oracle replication on those tables because Oracle replication has restrictions on tables with LONG and BLOB datatpyes. Is this true? If so how do somebody go about replicating tables of this sort?

    Any links to documentation around this subject would be great.

    Thanks so much.

  2. #2
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204

    Re: Oracle replication and long/blob datatypes

    Originally posted by ryanveach
    A very general but hopfully a simple question.

    Our company's schema has a few tables that have columns of datatypes LONG and BLOB. A customer of ours is complaining that they cannot run Oracle replication on those tables because Oracle replication has restrictions on tables with LONG and BLOB datatpyes. Is this true? If so how do somebody go about replicating tables of this sort?

    Any links to documentation around this subject would be great.

    Thanks so much.
    Long columns are not replicated. Blobs are. It's in the standard Oracle Advanced Replication documentation. The doc's can be found at OTN.Oracle.Com

    HTH,
    Patrick

  3. #3
    Join Date
    Apr 2003
    Location
    London
    Posts
    2

    Re: Oracle replication and long/blob datatypes

    Oracle replicator does not have BLOB and CLOB support, and is a very difficult tool to configure also. I suggest using a product by datamirror - check out the product Transformation Server at www.datamirror.com


    Originally posted by ryanveach
    A very general but hopfully a simple question.

    Our company's schema has a few tables that have columns of datatypes LONG and BLOB. A customer of ours is complaining that they cannot run Oracle replication on those tables because Oracle replication has restrictions on tables with LONG and BLOB datatpyes. Is this true? If so how do somebody go about replicating tables of this sort?

    Any links to documentation around this subject would be great.

    Thanks so much.

Posting Permissions

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