Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problems migrating data from MySQL to Oracle

651310Jul 22 2008 — edited Jul 23 2008
Hello!
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!!

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 20 2008
Added on Jul 22 2008
4 comments
3,701 views