wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes does Materilized view support  XMLTYPE Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "does Materilized view support  XMLTYPE" Watch "does Materilized view support  XMLTYPE" New topic

does Materilized view support XMLTYPE

Pratibha Malhotra
Ranch Hand

Joined: Dec 21, 2003
Posts: 199
Hi I am using Materilized views to replicate data. One of my table contains XMLType Datatype.

I get an following error, while creating materilized view on this table.
ORA-32331: type "SYS"."XMLTYPE" is incompatible with the master site

Kindly help..

~ Pratibha Malhotra<br /> <br />Sun Certified Java Programmer<br />SCEA 1.4 (In Progress)<br />~~~~~~~~~~~~~~~~~~~~~~~~~~~<br />"Many of life's failures are people who did not realize how close they were to success when they gave up!!"
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30123

Oracle has an "xmltype view." I'm not sure if a materialized view can be used instead.

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
I agree. Here's the link: http://aspose.com/file-tools
subject: does Materilized view support XMLTYPE
Similar Threads
HOw to Convert org.w3c.dom.Document to oracle.xdb.XMLType
Eclipselink, oracle 11 and clobs
Oracle XMLType data size
how to use data of type XMLTYPE in database in java
confused about primary key