Problems migrating data from MySQL to Oracle
651310Jul 22 2008 — edited Jul 23 2008Hello!
I'm a beginner to SQL Developer and Oracle and I'm trying to migrate a database from MySQL 5.0 to Oracle 10g Express Edition using SQL Developer 1.5.1. Everything has gone well until I have tried to migrate the data from my original database (I am using the option Migration->Migrate data).
The following error appears:
Failed to disable constraints: Data Move
And the following exception:
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1606)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1571)
at oracle.dbtools.migration.datamove.online.ConstraintHandler.disableDetail(ConstraintHandler.java:187)
at oracle.dbtools.migration.datamove.online.ConstraintHandler.disableConstraints(ConstraintHandler.java:98)
at oracle.dbtools.migration.datamove.online.ConstraintHandler.disableConstraints(ConstraintHandler.java:124)
at oracle.dbtools.migration.datamove.online.DataMoveWorker.doWork(DataMoveWorker.java:238)
at oracle.dbtools.migration.datamove.online.DataMoveRunner.doWork(DataMoveRunner.java:58)
at oracle.dbtools.migration.workbench.core.ui.AbstractMigrationProgressRunnable.run(AbstractMigrationProgressRunnable.java:161)
at oracle.dbtools.migration.workbench.core.ui.MigrationProgressBar.run(MigrationProgressBar.java:569)
at java.lang.Thread.run(Thread.java:595)
In the migration log, it seems that the migration is being done (there are messages saying that the rows of a given table have been imported), but when it is going to finalize there is a Primary Key Violation for every primary key constraint I have, and no data appears in the tables.
I thought that there could be some problem with the privileges granted to my repository user but I granted all of the priveleges listed in the help menu and the error still comes up. Also, all tables exist in the repository and in the user the repository creates, so I don't understand why there is an exception indicating that the table doesn't exist.
Does someone have any idea of what is happening and how can I solve it?
Thank you so much!!