This discussion is archived
1 Reply Latest reply: Feb 13, 2012 6:29 AM by wkobargs RSS

SQL Developer Migrate mySQL to 11g gets ORA-00972 due to 30 char name limit

916778 Newbie
Currently Being Moderated
I am running MySQL version 5.5.30 server, SQL Developer 3.0.04 Build MAIN-04.34, and Oracle Enterprise Server 11.2.0.1.0, and using Migrate option to move both data dictionary and data from mysql to Oracle
Most of the steps worked fine using OnLine option: used Capture just fine to generate the repositiory, and Convert generated DDL script just fine in the SQL Developer file folder.
It failed to create users due to privs, but I created them manually: emulation user and also the MYSQL data schema user, after which I took the generated DDL, connected to my Oracle data schema user, and ran the DDL to basically create all the objects. And found out that over 50 tables / column names from MYSQL are longer then 30 char, and thus the generated DDL fails to create objects..

Question - I can manually replace the names with shorter 30 char names, but if I do, my data migration step will not work.
i cannot find references to 'name too long' problem anywhere is SQL Server documentation..

here is the Oracle error example:

Error report:
SQL Error: ORA-00972: identifier is too long
00972. 00000 - "identifier is too long"
*Cause:    An identifier with more than 30 characters was specified.
*Action:   Specify at most 30 characters.
Creating Primary Key Constraint PRIMARY_1 on table bank_account ...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points