Solved

Mysql to Oracle Migration

Posted on 2014-01-07
3
394 Views
Last Modified: 2014-06-10
Hi ,

 I had migrated 2 Databases say Test1 & test2 from Mysql to Oracle using the Standard Mysql Migration using Oracle developer tool, it showed success.

What I would like to know the DB name of these test1 & test2 in Oracle.
What would be the username & passwords to access these databases.
0
Comment
Question by:asivaprasad
3 Comments
 
LVL 12

Accepted Solution

by:
praveencpk earned 500 total points
ID: 39761850
>>What I would like to know the DB name of these test1 & test2 in Oracle.<<

for migrating the data from MYSQL to ORACLE you need to first create the database in oracle and should make use of it for migration. so the DB name will be the same to which you migrated the data. If you have not created the oracle instance before migration then what was the connection string you gave while migration also let us know what is teh tool you used for migration.

Here are few doc which take you through the migration steps using oracle SQL developer tool.

http://www.oracle.com/technetwork/issue-archive/2007/07-sep/o57sql-100253.html

http://docs.oracle.com/cd/E25259_01/appdev.31/e24285/migration.htm
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 40123995
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now