ERPstuff - Oracle EBS Community

You love we care since 2006 by Malik Sikandar Hayat.
https://erpstuff.com/

Migration DB2 Database into Oracle 10g

https://erpstuff.com/viewtopic.php?t=8292

Page 1 of 1

Migration DB2 Database into Oracle 10g

Posted: Wed Mar 31, 2010 4:39 am
by Zahhus277
Dear All

I am migrating DB2 UDP 8 (O/S Windows) into Oracle 10g Database using Oracle Workbench.

I am facing problem while loading source model.

Error name is

Failed to Truncate Source Model. ORA-00942: Table or View does not exists

Thanks

Zaheer Hussain

Posted: Sat Apr 03, 2010 9:13 pm
by amirtai
Hi there

Did you make sure that ODBC connectivity is establishedt? Are you using the required driver version?

Amir

Posted: Wed Apr 07, 2010 2:34 am
by Zahhus277
Sorry for missing DB2 Version. It is Actually DB2 UDB 7.2 .

Connection from DB2 Client (installed on my system and client version is 8) and ODBC is working fine. Actually I get this message after the following screens

capture source database >> IBM DB2 UDB Details >>
userid,password,databasenames >> data type mapping screen >> next >> create oracle mode screen (yes) >> finish >> error occur
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited