Home » Server Options » Streams & AQ » how to deal with my problem (10.2.0.1)
how to deal with my problem [message #556067] Thu, 31 May 2012 02:03 Go to next message
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
Re: how to deal with my problem [message #556068 is a reply to message #556067] Thu, 31 May 2012 02:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Upgrade to 11.2

Regards
Michel
Re: how to deal with my problem [message #556070 is a reply to message #556068] Thu, 31 May 2012 02:43 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
Michel,do you means that Streams can support the XMLTYPE in 11.2 ?
Re: how to deal with my problem [message #556074 is a reply to message #556070] Thu, 31 May 2012 02:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What does the documentation say?

Regards
Michel
Re: how to deal with my problem [message #556078 is a reply to message #556074] Thu, 31 May 2012 03:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
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
Re: how to deal with my problem [message #556079 is a reply to message #556078] Thu, 31 May 2012 03:40 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
Michel!
Previous Topic: streams issue
Next Topic: DEQUEUE Option
Goto Forum:
  


Current Time: Thu Mar 28 06:01:06 CDT 2024