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".
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
Last activity: May 4, 2025, 04:04 PM