Hi, i'm trying to migrate a MySQL database to Oracle 19c using the migration wizard available in Oracle SQL Developer, the result is that the procedure create the user and the tables but the tables are empty and i receive the following error "ORA-00942 table or view does not exist".
<img src="https://objectstorage.us-phoenix-1.oraclecloud.com/p/BqK85Rn1zA5MP0vYiqbAdPgs7Z6OmMxw8SD3WCFVm5kY8uReidZ1KPIKkgJ1hCkG/n/axciphqpnohg/b/forums-legacy/o/uploads/IR7NUMABF10R/migrazionedbfail-png.png" alt="migrazionedbfail.PNG"><record>
<date>2023-01-24T10:36:38.942646600Z</date>
<nanos>646600</nanos>
<level>INFO</level>
<class>oracle.dbtools.migration.convert.ConverterWorker</class>
<message>test.testtable.TestString</message>
<param>testtable, MD_TABLES, 8795201Converti</param>
</record>
</record>
</record>
<record>
<date>2023-01-24T10:36:48.641027500Z</date>
<nanos>27500</nanos>
<logger>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</logger>
<level>SEVERE</level>
<class>oracle.dbtools.migration.workbench.core.logging.MigrationLogUtil</class>
<message>Generation phase
ORA-00942: tabella o vista inesistente
</message>
<param>oracle.dbtools.metadata.persistence.PersistableObject.doUpdate(PersistableObject.java:364)</param>
<param>oracle.dbtools.metadata.persistence.PersistableObject.save(PersistableObject.java:186)</param>
<param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doGenerate(FullMigrateTask.java:1303)</param>
<param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doMaskBasedActions(FullMigrateTask.java:437)</param>
<param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:321)</param>
<param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:154)</param>
<param>oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:199)</param>
<param>java.base/java.util.concurrent.FutureTask.run(Unknown Source)</param>
<param>oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:702)</param>
<param>java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)</param>
<param>java.base/java.util.concurrent.FutureTask.run(Unknown Source)</param>
<param>java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)</param>
<param>java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)</param>
<param>java.base/java.lang.Thread.run(Unknown Source)</param>
<param>oracle.dbtools.migration.workbench.core.logging.LogInfo@40a54f33</param>
<exception>
<message>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask$FullMigrateTaskException: Generation phase
ORA-00942: tabella o vista inesistente
</message>
<frame>
<class>oracle.dbtools.metadata.persistence.PersistableObject</class>
<line>364</line>
</frame>
<frame>
<class>oracle.dbtools.metadata.persistence.PersistableObject</class>
<line>186</line>
</frame>
<frame>
<class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
<line>1303</line>
</frame>
<frame>
<class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
<line>437</line>
</frame>
<frame>
<class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
<line>321</line>
</frame>
<frame>
<class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
<line>154</line>
</frame>
<frame>
<class>oracle.dbtools.raptor.backgroundTask.RaptorTask</class>
<line>199</line>
</frame>
<frame>
<class>java.util.concurrent.FutureTask</class>
</frame>
<frame>
<class>oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask</class>
<line>702</line>
</frame>
<frame>
<class>java.util.concurrent.Executors$RunnableAdapter</class>
</frame>
<frame>
<class>java.util.concurrent.FutureTask</class>
</frame>
<frame>
<class>java.util.concurrent.ThreadPoolExecutor</class>
</frame>
<frame>
<class>java.util.concurrent.ThreadPoolExecutor$Worker</class>
</frame>
<frame>
<class>java.lang.Thread</class>
</frame>
</exception>
</record>
<record>
<date>2023-01-24T10:36:48.646027400Z</date>
<nanos>27400</nanos>
<logger>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</logger>
<level>WARNING</level>
<class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
<message>L'esecuzione dello script generato include errori: FAILED : Migrazione del database : FAILED</message>
<param>oracle.dbtools.migration.workbench.core.logging.LogInfo@62446fcd</param>
</record>
I've also tryied to create the user and grant unlimited quota on all the table_spaces but the result is the same. Anyone have an idea of what could be the problem?