MySQL Database

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!

From MySQL to Oracle 10g

AnnieMNov 20 2018 — edited Dec 7 2018

Hi,

We are in a Windows 7 environment (so I downloaded MySQL Workbench 6.3, MySQL Server 5.7)

I have a large MySQL .sql file which I ran to create the tables, indexes, and other objects.

Now I need to either:

(1) Convert the .sql script to PL/SQL

(2) Migrate the MySQL objects to Oracle 10g

I downloaded SQL Develper ( Version 18.3.0.277) and set up the connections to

(1) our Oracle database

(2) MySQL

so I can view the objects in both

I followed steps here to set up a repository with the appropriate rights and table space:

https://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html

When I right click that though to "Create Repository" I receive errors:

So I make sure all objects are deleted and try again with the same results.

I have seen this error mentioned online but I have confirmed the user, MIGRATION, who is associated with Migration_Repository has the correct rights and table space.

Does anyone know how to fix or if there is another option?

I know SQL Developer has a "Copy to Oracle" option which works -- but I also need to copy over indexes.

Thank you for your help and Happy Thanksgiving

(I am grateful for this community - thank you!)

Annie

morgalr

That is a lot of code to go through, so I am not.

Let me ask you this: I see you have a portion that is marked as recursive, do you recursively call the loading of the images? If you do therein is your problem.

RuGI:.

Have you tried to define your Layout at level of the class as static attribute?
You only require one.

Each time you use a BufferedImage, after painting the image invokes flush

picture.flush();

picture = null;

---

RuGI

Max8090-JavaNet

Thanx for the answer.

Can you tell me, which lines are recursive?

It was not my intent to do a recursive call. If so, this could maybe the problem.

Max8090-JavaNet

Yes, but didn't help.

Max8090-JavaNet

The problem is solved. I don't use the class OverlayLayout anymore. The layout looks quite different, but now it works.

1 - 5

Added on Nov 20 2018

#mysql

4 comments

616 views

MySQL Database

From MySQL to Oracle 10g

Comments

Post Details