File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "does Materilized view support  XMLTYPE" Watch "does Materilized view support  XMLTYPE" New topic
Author

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
Marshal

Joined: May 26, 2003
Posts: 30075
    
149

Rewa,
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