Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

migrate tables to a new schema in oracle

Status
Not open for further replies.

crsdev

Programmer
Sep 29, 2006
96
US
Hello All,
I am trying to migrate some tables that are in mysql database to oracle without deleting/altering the tables in mysql.
can someone please point me to the right direction to how to go about doing this.


THanks in advance.
 
you could dump the tables from mysql, and then use some kind of import mechanism to import the tables into oracle.

I suppose oracle can handle sql command files. If so try

mysqldump databasename > dbfile.sql

for additional help on the mysldump command type

mysqldump /?

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top