MySQL Forums
Forum List  »  MySQL Workbench

Re: Migrate Oracle Table to MySQL
Posted by: Denise Ayala
Date: July 22, 2015 08:15AM

hi Peter - thanks for responding - is there a way to post a screenshot here.

I did have an error during the Migration however I did manage to spool out the output into a script.sql file records from the oracle database table. I am now in the MYSQL query browser attempting to create the table first, then import the records from the script.sql file that contains the table records but am getting an error.

"create command denied to user swa@oracledb for table mailswa".

I suppose I need to grant all table privileges to swa in MYSQL.

Options: ReplyQuote


Subject
Views
Written By
Posted
1177
July 20, 2015 02:00PM
Re: Migrate Oracle Table to MySQL
585
July 22, 2015 08:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.