Missing Oracle Schema in SSMA Object Explorer We are currently working on a project to move all of our disparate DBs (MySQL, Oracle, older versions of MS SQL) to SQL Server 2014. So far, pretty much everything has gone smoothly, however, there is one Oracle Database (10g 10.2.0.5), which we're trying to migrate using SSMA that just doesn't show up in the SSMA object explorer.

I have tried connecting to this database using the schema owner, the sys AND the system users and it just never shows up. ALL the other schemas on this instance show up and we can migrate them successfully.

Has anyone come across this issue before? Could anyone suggest possible reasons for this? I - and the SQL Server DBA - am stumped. In the interim, we're migrating subsets of data using smacked-together Perl scripts, but this is obviously not ideal.
Try this

1) Open the project

2) Remove the checkbox on the Schemas branch in the Oracle Metadata Explorer
Right-click on the Schemas branch in the Oracle Metadata Explorer and select Refresh from Database.  This will automatically put a checkbox on ALL schemas.
Let the refresh run.  This step can take a good amount of time.

3) Save the project