Solved

Mysql to Oracle Migration

Posted on 2014-01-07
3
427 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

808 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