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
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 Posts
Re: DMT : not able to connect to ORACLE2012-05-15T12:55:55ZThis is the accepted answer. This is the accepted answer.It 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.