# Error with Schema Compare in Toad 10.5

**URL:** <https://forums.toadworld.com/t/error-with-schema-compare-in-toad-10-5/9508>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [May 14, 2010, 4:35am UTC](https://forums.toadworld.com/t/error-with-schema-compare-in-toad-10-5/9508 "2010-05-14T04:35:14Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [May 14, 2010, 4:35am UTC](https://forums.toadworld.com/t/error-with-schema-compare-in-toad-10-5/9508/1 "2010-05-14T04:35:14Z")

</div>

Hi,

I’m having an issue using the schema compare feature of the TOAD DBA module.

I’m comparing schemas on 2 separate db instances , one is a v9.2 db and the other is the same as the first upgraded to v10.2.

I log on as system on both instances and then go to the schema compare I can successfully compare one schema, lets call that one schema1 but another, call it schema2, fails with an ORA-00942 : Table or view does not exist.

Using SQL Tracker the sql causing the problem is :

Timestamp: 14/05/2010 09:52:27

select table\_name, column\_name, xmlschema, element\_name, storage\_type  
from sys.DBA\_XML\_TAB\_COLS  
where owner = ‘SCHEMA2’

Error occurred: [942] (ORA-00942: table or view does not exist  
)

Which I assume is failing when it runs on the 9.2 instance as this doesn’t have this but the 10.2 instance does.

Tracking the sql for schema1 this piece of SQL isn’t executed for that compare, so why is it for schema2?

Any help is welcome as getting this working would be a big help.

Thanks,

Jonathan

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [May 14, 2010, 8:04am UTC](https://forums.toadworld.com/t/error-with-schema-compare-in-toad-10-5/9508/2 "2010-05-14T08:04:25Z")

</div>

That query is only executed if you have a table with an XMLTYPE column.

I see this view in my 9.2 databases.

Can you verify if it exists or if you just don’t have privileges on it?

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [May 14, 2010, 9:34am UTC](https://forums.toadworld.com/t/error-with-schema-compare-in-toad-10-5/9508/3 "2010-05-14T09:34:00Z")

</div>

John – is it possible that when DBA ran DBCA to create the database they  
unchecked XML support or some other option that could make that disappear ???

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [May 14, 2010, 9:41am UTC](https://forums.toadworld.com/t/error-with-schema-compare-in-toad-10-5/9508/4 "2010-05-14T09:41:45Z")

</div>

I’ve never known Oracle to leave out data dictionary views based on  
options, but could be.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [May 14, 2010, 10:17am UTC](https://forums.toadworld.com/t/error-with-schema-compare-in-toad-10-5/9508/5 "2010-05-14T10:17:41Z")

</div>

> I've never known Oracle to leave out data dictionary views based on options,  
> but could be.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [May 14, 2010, 10:58am UTC](https://forums.toadworld.com/t/error-with-schema-compare-in-toad-10-5/9508/6 "2010-05-14T10:58:01Z")

</div>

Thanks for the legwork, Rich.

I’ve made a change to the next beta so it won’t barf if that view  
doesn’t exist.

Jonathan – To get the error to go away in Toad 10.5, someone will have to  
run catxdbv.sql on that database.

-John

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [May 18, 2010, 2:52pm UTC](https://forums.toadworld.com/t/error-with-schema-compare-in-toad-10-5/9508/7 "2010-05-18T14:52:48Z")

</div>

Okay John.

big thanks to everyone for your replies!

Jonathan