Migration DB2 Database into Oracle 10g

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
Zahhus277
Posts: 3
Joined: Mon Nov 12, 2007 3:18 am
Location: Pakistan

Migration DB2 Database into Oracle 10g

Post 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
amirtai
Posts: 138
Joined: Sat Apr 08, 2006 5:54 pm
Location: Canada
Contact:

Post by amirtai »

Hi there

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

Amir
Zahhus277
Posts: 3
Joined: Mon Nov 12, 2007 3:18 am
Location: Pakistan

Post 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
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests