# \[TDM 3.1.5.6\] ORA-00942 in RE

**URL:** <https://forums.toadworld.com/t/tdm-3-1-5-6-ora-00942-in-re/1593>\
**Category:** Toad Data Modeler\
**Created:** [March 11, 2008, 8:57am UTC](https://forums.toadworld.com/t/tdm-3-1-5-6-ora-00942-in-re/1593 "2008-03-11T08:57:54Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![igorkarpyahoo.com](https://avatars.discourse-cdn.com/v4/letter/i/a8b319/32.png) [@igorkarpyahoo.com](https://forums.toadworld.com/u/igorkarpyahoo.com)\
**Post date:** [March 11, 2008, 8:57am UTC](https://forums.toadworld.com/t/tdm-3-1-5-6-ora-00942-in-re/1593/1 "2008-03-11T08:57:54Z")

</div>

Hello All,

I am getting the following error while Reverse Engineering Oracle 10g database

Source: CS3 - Internal error  
Script: REDataMigratorDBOR  
Description: ORA-00942: table or view does not exist

Row: 4956  
Column: 5

Callstack:  
REDataMigratorDBOR

the wizard completes Reversing users… and Reversing roles… but fails on Reversing table details…

The RE is done under the user with DBA privileges

Any help and/or hints would be appreciated

---

<div class="post-metadata">

**Author:** ![vladka](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vladka/32/41_2.png) [@vladka](https://forums.toadworld.com/u/vladka)\
**Post date:** [March 11, 2008, 10:48am UTC](https://forums.toadworld.com/t/tdm-3-1-5-6-ora-00942-in-re/1593/2 "2008-03-11T10:48:05Z")

</div>

Hello,

The problem occurs during loading of the system table ALL\_XML\_TAB\_COLS.

To avoid this, please do not select checkbox “Load XMLType Column Properties for Tables”. It should work fine then.

For further verification, we would like to ask you for the following information:

- exact version of Oracle db you use,
- please check out if you have all the necessary privileges to load this table.  
Thanks for the details.

Regards,

Vladka + TDM Team

---

<div class="post-metadata">

**Author:** ![igorkarpyahoo.com](https://avatars.discourse-cdn.com/v4/letter/i/a8b319/32.png) [@igorkarpyahoo.com](https://forums.toadworld.com/u/igorkarpyahoo.com)\
**Post date:** [March 13, 2008, 7:31am UTC](https://forums.toadworld.com/t/tdm-3-1-5-6-ora-00942-in-re/1593/3 "2008-03-13T07:31:04Z")

</div>

Hello vladka,

thank a lot for the prompt answer. Unchecking the checkbox solved the issue.

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit

I cannot check the second option cause we do not have this view at all. As far as I remember it is an optional view installed as a part of XDB.

Best regards,  
Igor Karp

---

<div class="post-metadata">

**Author:** ![clhoste](https://avatars.discourse-cdn.com/v4/letter/c/f08c70/32.png) [@clhoste](https://forums.toadworld.com/u/clhoste)\
**Post date:** [April 22, 2010, 1:03pm UTC](https://forums.toadworld.com/t/tdm-3-1-5-6-ora-00942-in-re/1593/4 "2010-04-22T13:03:04Z")

</div>

I am having the same problem with TOAD 3.4.16 on 10.2.01.

I’ve deselected everything except ‘relationships’ and ‘load all objects for selected schema’. I don’t get any tables in the selection window, nor any results after executing  
it.

Thanks,  
CML

---

<div class="post-metadata">

**Author:** ![vladka](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vladka/32/41_2.png) [@vladka](https://forums.toadworld.com/u/vladka)\
**Post date:** [April 27, 2010, 4:17am UTC](https://forums.toadworld.com/t/tdm-3-1-5-6-ora-00942-in-re/1593/5 "2010-04-27T04:17:04Z")

</div>

Hello,

What objects will be loaded is defined on page What to Reverse. If you deselected all (except for relationships), nothing was loaded. Neither were relationships, which is ok. Why? - Because if you want to load relationships, you have to select also tables (but you deselected them).

If you have any questions, please write me back. Thanks.

Regards,

Vladka