Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Sqlyog With Oracle

forums › forums › SQLyog › Using SQLyog › Sqlyog With Oracle

Tagged: ,

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • March 12, 2015 at 9:23 am #13332
      a.shivam
      Member

      Hi,

       

      I am using SQLyog trail version to convert some oracle tables to mysql. But when i do that some of the tables giving error. Attaching is the error log file for the same.

      Can you please help me on the issue and also please provide me the steps to fix the issue.

       

      I am trying to migrate the data by checking “set_foreign_key_set=0”

       

      error as follows:

       

      ERROR: 1005, Can’t create table ‘LOCAL_TEST.#sql-2e93_104’ (errno: 150)

      Table:NUMBERS

      Sql: ALTER TABLE `NUMBERS` ADD FOREIGN KEY `NUMBERS_PREFIX_FK`(`COUNTRY_CODE`,`PREFIX`)REFERENCES `PREFIX`(`COUNTRY_CODE`,`PREFIX`)ON DELETE  NO ACTION ON UPDATE  CASCADE  

      ERROR: Import aborted…

       

      Regards

      Shivam

    • March 12, 2015 at 1:18 pm #35244
      peterlaursen
      Participant

      I have replied in the ticket you have created.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.