sign in | join about | help | sitemap
Connecting Tech Pros Worldwide
t3chn0n3rd's Avatar

oracle to db2 export


Question posted by: t3chn0n3rd (Guest) on January 17th, 2008 10:15 PM
Does anyone know how to export data from an Oracle database to a DB2
database?
3 Answers Posted
m's Avatar
Guest - n/a Posts
#2: Re: oracle to db2 export

t3chn0n3rd wrote:
Quote:
Originally Posted by
Does anyone know how to export data from an Oracle database to a DB2
database?

Export comma delimited ascii files from Oracle - import into DB2

Michael Rudolph's Avatar
Michael Rudolph January 18th, 2008 01:15 PM
Guest - n/a Posts
#3: Re: oracle to db2 export

t3chn0n3rd wrote:
Quote:
Originally Posted by
Does anyone know how to export data from an Oracle database to a DB2
database?


Hi,

try the Redbook named Oracle to DB2 Conversion Guide for Linux, UNIX,
and Windows


http://www.redbooks.ibm.com

Michael
Bob Jones's Avatar
Guest - n/a Posts
#4: Re: oracle to db2 export


"t3chn0n3rd" <darrin_allen@japan.comwrote in message
news:7113dc0a-5d9f-48fe-91f6-56c4f894eb91@e25g2000prg.googlegroups.com...
Quote:
Originally Posted by
Does anyone know how to export data from an Oracle database to a DB2
database?


You can't. Oracle export is proprietary. There are 2 options I can think of.

1. Create flat files from Oracle tables and then import into DB2.
2. Create database link between Oracle and DB2 with OHS.



 
Not the answer you were looking for? Post your question . . .
197,050 members ready to help you find a solution.
Join Bytes.com

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 197,050 network members.
Post your question now . . .
It's fast and it's free

Popular Articles

Top Community Contributors