| 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: 26141
|
|
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
|
|
 |
|
|
subject: does Materilized view support XMLTYPE
|
|
|
0
