Sample Header Ad - 728x90

Migration MySQL to Oracle 19C error ORA-00942

0 votes
1 answer
379 views
I'm trying to migrate a simple MySQL test 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". enter image description here enter image description here 2023-01-25T08:52:10.649730400Z 730400 oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle INFO oracle.dbtools.migration.convert.ConverterWorker Eseguito il coalesce del catalogo MySQL, schema test nello schema singolo test Convert.COALESCED oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle MySQL test test oracle.dbtools.migration.workbench.core.logging.LogInfo@61735376 2023-01-25T08:52:11.575035900Z 35900 oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle INFO oracle.dbtools.migration.core.util.MultiLevelLogManager Colonna 'number' modificato in 'number_' (Caratteri non validi, parola riservata o conflitto) oracle.dbtools.migration.workbench.core.logging.LogInfo@61735376 2023-01-25T08:52:14.770235800Z 235800 oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle INFO oracle.dbtools.migration.workbench.core.ui.FullMigrateTask Conversione completata in 0 secondi oracle.dbtools.migration.workbench.core.logging.LogInfo@61735376 2023-01-25T08:52:20.872501Z 501000 oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle SEVERE oracle.dbtools.migration.workbench.core.logging.MigrationLogUtil Generation phase ORA-00942: tabella o vista inesistente oracle.dbtools.metadata.persistence.PersistableObject.doUpdate(PersistableObject.java:364) oracle.dbtools.metadata.persistence.PersistableObject.save(PersistableObject.java:186) oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doGenerate(FullMigrateTask.java:1303) oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doMaskBasedActions(FullMigrateTask.java:437) oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:321) oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:154) oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:199) java.base/java.util.concurrent.FutureTask.run(Unknown Source) oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:702) java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) java.base/java.util.concurrent.FutureTask.run(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.base/java.lang.Thread.run(Unknown Source) oracle.dbtools.migration.workbench.core.logging.LogInfo@15963e4b oracle.dbtools.migration.workbench.core.ui.FullMigrateTask$FullMigrateTaskException: Generation phase ORA-00942: tabella o vista inesistente oracle.dbtools.metadata.persistence.PersistableObject 364 oracle.dbtools.metadata.persistence.PersistableObject 186 oracle.dbtools.migration.workbench.core.ui.FullMigrateTask 1303 oracle.dbtools.migration.workbench.core.ui.FullMigrateTask 437 oracle.dbtools.migration.workbench.core.ui.FullMigrateTask 321 oracle.dbtools.migration.workbench.core.ui.FullMigrateTask 154 oracle.dbtools.raptor.backgroundTask.RaptorTask 199 java.util.concurrent.FutureTask oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask 702 java.util.concurrent.Executors$RunnableAdapter java.util.concurrent.FutureTask java.util.concurrent.ThreadPoolExecutor java.util.concurrent.ThreadPoolExecutor$Worker java.lang.Thread 2023-01-25T08:52:20.877506400Z 506400 oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle WARNING oracle.dbtools.migration.workbench.core.ui.FullMigrateTask L'esecuzione dello script generato include errori: FAILED : Migrazione del database : FAILED oracle.dbtools.migration.workbench.core.logging.LogInfo@2b459c32 MySQL queries: CREATE DATABASE test /*!40100 COLLATE 'utf8_general_ci' */; CREATE TABLE test ( number INT(11) NULL DEFAULT NULL, string VARCHAR(50) NULL DEFAULT NULL ) ENGINE=InnoDB; INSERT INTO test.test (number, string) VALUES ('1', 'test'); INSERT INTO test.test (number, string) VALUES ('2', 'test'); This is the master.sql generated from the wizard: SET ECHO ON SET VERIFY ON SET FEEDBACK ON SET DEFINE ON CLEAR SCREEN set serveroutput on COLUMN date_time NEW_VAL filename noprint; SELECT to_char(systimestamp,'yyyy-mm-dd_hh24-mi-ssxff') date_time FROM DUAL; spool "Test5_&filename..log" -- Password file execution @passworddefinition.sql PROMPT Dropping Role ROLE_Test5 ... DROP ROLE ROLE_Test5 ; PROMPT Creating Role ROLE_Test5 ... CREATE ROLE ROLE_Test5 ; -- PROMPT Drop test user -- drop user test cascade; PROMPT Create user test CREATE USER test IDENTIFIED BY &&test_password PASSWORD EXPIRE ACCOUNT LOCK /* DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP */; GRANT CREATE SESSION, RESOURCE, CREATE VIEW, CREATE MATERIALIZED VIEW, CREATE SYNONYM, UNLIMITED TABLESPACE TO test; -- PROMPT Drop Emulation user -- drop user Emulation cascade; PROMPT Create user Emulation CREATE USER Emulation IDENTIFIED BY &&Emulation_password PASSWORD EXPIRE ACCOUNT LOCK /* DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP */; GRANT CREATE SESSION, RESOURCE, CREATE VIEW, CREATE MATERIALIZED VIEW, CREATE SYNONYM, UNLIMITED TABLESPACE TO Emulation; set define on prompt connecting to Emulation alter session set current_schema=Emulation; set define off set define on prompt connecting to test alter session set current_schema=test; set define off -- DROP TABLE test CASCADE CONSTRAINTS; PROMPT Creating Table test ... CREATE TABLE test ( number_ NUMBER(10,0), string VARCHAR2(50 CHAR) ); GRANT ALL ON test TO ROLE_Test5; set define on prompt connecting to test alter session set current_schema=test; set define off spool off; COMMIT; 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?
Asked by Tinfo (1 rep)
Jan 24, 2023, 10:59 AM
Last activity: May 4, 2025, 04:04 PM