OraFAQ Forum: Server Utilities » migration from oracle to db2?

Home » RDBMS Server » Server Utilities » migration from oracle to db2?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

migration from oracle to db2? [message #153321]

Sat, 31 December 2005 08:03

pashah72
Messages: 6
Registered: November 2005

Junior Member

Happy New Year

I have an application ready with database oracle but I also need this application to be set with db2. How to export tables & its data from oracle to db2 with ease? I surf the net but not written in easy way.

Looking forward for a early reply

Thanks

Report message to a moderator

Re: migration from oracle to db2? [message #153952 is a reply to message #153321]

Thu, 05 January 2006 01:38

pashah72
Messages: 6
Registered: November 2005

Junior Member

I tried IBM toolkit but looks like it doesn't support db2 ver 7.1 because can't get oracle connection mssg is displayed.

Report message to a moderator

Re: migration from oracle to db2? [message #154209 is a reply to message #153321]

Fri, 06 January 2006 04:34

pashah72
Messages: 6
Registered: November 2005

Junior Member

Hello

while migrating I got this exception.

class com.ibm.db2.jcc.b.SqlException while getting the table names : DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSSH200

What does it means?

Report message to a moderator

Previous Topic:	datapump - can it export view data?
Next Topic:	i need to pass the argument to the (spool_file.sql) sql file such as "d:\gopal\spool.lst"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 04:35:42 CDT 2024