Skip to Main Content

Migration from MySQL to Oracle 19C error ORA-00942

User_ZGN8QJan 24 2023

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?

Comments
Post Details
Added on Jan 24 2023
1 comment
45 views