Re: Oracle 10g &11g Streams Support for BLOBs and CLOBs
- From: "Mark Brinsmead" <pythianbrinsmead@xxxxxxxxx>
- To: afatkulin@xxxxxxxxx
- Date: Fri, 13 Jun 2008 21:25:10 -0600
I may be mistaken, but I believe I recall seeing a statement that NCLOB is *
not* supported on at least some releases.
Technically, this is not the same thing as a CLOB, but sometimes we don't
distinguish between CLOB / NCLOB as carefully as perhaps we should...
Anyway, supported data types should be reported in the relevant Streams
Reference manual.
On Fri, Jun 13, 2008 at 7:57 AM, Alexander Fatkulin <afatkulin@xxxxxxxxx>
wrote:
> they are supported, yes
>
> we hit a strange bug recently where if (a) your source DB is 10.2.0.3 and
> (b) your target DB is 10.2.0.4 and (c) you have a partitioned table with
> LOB and (d) you are doing an update which causes row migration and (d) you
> are using downstream capture => capture will crash. 11G expressed the same
> behavior and upgrading source to 10.2.0.4 fixed the issue.
>
> the above is very specific set of events but the point is -- don't forget
> to test your cases first, there still seems to be a lot of bugs even after
> the thing (Streams) has existed for such a long time....
>
>
> On Fri, Jun 13, 2008 at 1:51 AM, Blessing Kamutande <kamutandeb@xxxxxxxxx>
> wrote:
>
>> Hi list,
>>
>> Can someone tell me if Oracle 10g and 11g Streams support BLOB and CLOB
>> datatypes.
>>
>> Thank you in advance for the help.
>>
>> Kind Regards
>>
>> Blessing
>>
>
>
>
> --
> Alex Fatkulin,
> The Pythian Group,
> http://www.pythian.com/blogs/author/alexf
--
Cheers,
-- Mark Brinsmead
Senior DBA,
The Pythian Group
http://www.pythian.com/blogs
Other related posts:
