I am facing the same issue like when I am using IBM Data Movement Tool to migrate to DB2.I am able to connect to IBM DB2 database.but there is issue with source database Oracle 10g.the issue is "no user schema is found in your database".when I check in the console the error printed as
http://2012-05-15 16.26.02.015 Database Minor Version :2
java.sql.SQLException: ORA-00942: table or view does not exist.
Please help me to resolve this issue
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2012-05-15T12:55:55Z by SystemAdmin
Pinned topic DMT : not able to connect to ORACLE
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-05-15T12:55:55Z at 2012-05-15T12:55:55Z by SystemAdmin
SystemAdmin 110000D4XK708 PostsACCEPTED ANSWER
Re: DMT : not able to connect to ORACLE2012-05-15T12:55:55Z in response to ramakrishnamanuIt is a very old and known issue. IDMT hides known system provided schema and that list is in ExcludeSchema.properties in the the JAR file.
Create a sample schema in your Oracle database and it will show up.