OraFAQ Forum: Streams & AQ » how to deal with my problem

Home » Server Options » Streams & AQ » how to deal with my problem (10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to deal with my problem [message #556067]

Thu, 31 May 2012 02:03

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
There have a streams about a schema DEV,In the schema,there have a table contain XMLTYPE,the streams can not transport and raise,is there a way that can tansport other table except the XMLTYPE table?

ORA-26744: STREAMS capture process "CAPTURE_TEST" does not support "DEV"."TB_ORDER" because of the following reason:  
ORA-26783: Column data type not supported

Report message to a moderator

Re: how to deal with my problem [message #556068 is a reply to message #556067]

Thu, 31 May 2012 02:37

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Upgrade to 11.2

Regards
Michel

Report message to a moderator

Re: how to deal with my problem [message #556070 is a reply to message #556068]

Thu, 31 May 2012 02:43

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
Michel,do you means that Streams can support the XMLTYPE in 11.2 ?

Report message to a moderator

Re: how to deal with my problem [message #556074 is a reply to message #556070]

Thu, 31 May 2012 02:58

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What does the documentation say?

Regards
Michel

Report message to a moderator

Re: how to deal with my problem [message #556078 is a reply to message #556074]

Thu, 31 May 2012 03:19

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It took me less about 10 seconds to find the answer in the documentation.
Streams Concepts and Administration
Datatypes Applied

Regards
Michel

Report message to a moderator

Re: how to deal with my problem [message #556079 is a reply to message #556078]

Thu, 31 May 2012 03:40

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
Michel!

Report message to a moderator

Previous Topic:	streams issue
Next Topic:	DEQUEUE Option

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 20:56:44 CDT 2023