Re: Moving schema from DB2 to Oracle9i

From: Dave <x_at_x.com>
Date: Tue, 04 Jan 2005 22:03:14 GMT
Message-ID: <CoECd.3328$GG1.1133@text.news.blueyonder.co.uk>

"Harry Boswell" <Harry_Boswell@@deq.state.ms.us> wrote in message news:3i3mt0p83g34mkscsrlg0fr4is9e8krjv2_at_4ax.com...
> I've got to move the database portion of an application from DB2 to
> Oracle9i. I know essentially nothing about DB2; the agency hosting the
> DB2
> database knows nothing about Oracle. There is a contractor I can go to
> for
> information, but I need to minimize the amount of time I use with them.
> For
> the first cut, I simply need to take the DB2 schema and recreate it in an
> Oracle schema, and bring the existing data over. It isn't an emormous
> amount of data - probably less than 1 GB. Can I create a dblink to the
> DB2
> database and move objects that way? Would I have to use heteregenous
> services to accomplish that? What about third-party tools for this? And
> are there objects within the DB2 world that either don't have a
> corresponding object type in Oracle, or don't exactly correspond?
>
> Thanks,
> Harry Boswell

might be easier to export to a csv file from db2 and use sql loader or external tables Received on Tue Jan 04 2005 - 16:03:14 CST