Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Server Migration Assistant getting a ORA-00942 error when connecting to Oracle DB

2834791Mar 5 2018 — edited Dec 6 2018

I'm attempting to migrate some data from one of our Oracle databases to a Microsoft SQL Server. To do this I want to the Microsoft SQL Server Migration Assistant for Oracle (SSMA). Unfortunately when I try to connect the application errors out saying that an "Error occurred while collecting data". In the logs it says "Inner Exception #1: ORA-00942: table or view does not exist". I know that the server I'm using as well as the connection information is correct because I can connect using Oracle SQL Developer. Just wondering if any of you might have some experience using SSMA to migrate data over to MS SQL and whether you've encountered something like this before.

SQL Server Migration Assistant for Oracle 7.7.0

Oracle DB 12.1.0.2.0

MS SQL Server 2008 R2

This post has been answered by 2834791 on Mar 6 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2018

Added on Mar 5 2018

#general-database-discussions

7 comments

5,020 views