Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!z34g2000cwc.googlegroups.com!not-for-mail
From: "steph" <stephan0h@gmx.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: migrating data from mysql to oracle.
Date: 3 Mar 2006 00:05:49 -0800
Organization: http://groups.google.com
Lines: 9
Message-ID: <1141373149.839198.120930@z34g2000cwc.googlegroups.com>
References: <5cb0e62d1248c@uwe>
NNTP-Posting-Host: 81.223.198.149
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1141373155 21254 127.0.0.1 (3 Mar 2006 08:05:55 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 3 Mar 2006 08:05:55 +0000 (UTC)
In-Reply-To: <5cb0e62d1248c@uwe>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8) Gecko/20051111 Firefox/1.5,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 mail.biovertis.com:3128 (Squid/2.4.STABLE7)
Complaints-To: groups-abuse@google.com
Injection-Info: z34g2000cwc.googlegroups.com; posting-host=81.223.198.149;
   posting-account=ig33QwwAAAAFLc9JyV0mBY7uElDYBW_7
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262666

I have done this once by setting up a HSODBC-connection to the mysql
database. After this is setup importing data is reduced to
insert-into-select-from. The drawback is probably that it's a bit
tricky to set it up, and there are problems with some datatypes. Here's
how:
http://www.idevelopment.info/data/Oracle/DBA_tips/Heterogeneous_Services/HETERO_2.shtml

stephan