Toad World® Forums

TDM 6.1 ORA-00942: table or view does not exist

Hello All,

I’m trying to generate change script using TDM 6.1 and keep getting the following error:

"Source: Toad Data Modeler - Internal Error

Script: REDataMigratorDBOR11R2

Description: ORA-00942: table or view does not exist

row:2284

column:3

Callstack:

‘REDataMigratorDBOR’ from package ‘Object RE Database for Oracle’

7380.TDMError.png

I have access to all synonyms described here: https://support.quest.com/toad-for-oracle/kb/24103, however still having the issue.

I appreciate any help!

Thanks!

Hi.

It seems that you do Change Script against database and this process stop when query on system view SYS.ALL_SOURCE is doing.

Do you have permission SELECT on system view SYS.ALL_SOURCE? You can try run query “SELECT * FROM SYS.ALL_SOURCE”.

Regards,

Mario

Hi Mario,

Thank you so much for your reply! I do not have the access to the table; trying to get it now. Will post an update once that happens.

Thanks!

That was it! Thank you so much Mario!