• 1 reply
  • Latest Post - ‏2012-05-15T12:55:55Z by SystemAdmin
2 Posts

Pinned topic DMT : not able to connect to ORACLE

‏2012-05-15T11:08:32Z |

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 Database Minor Version :2
java.sql.SQLException: ORA-00942: table or view does not exist.

Please help me to resolve this issue


Updated on 2012-05-15T12:55:55Z at 2012-05-15T12:55:55Z by SystemAdmin
  • SystemAdmin
    708 Posts

    Re: DMT : not able to connect to ORACLE

    It is a very old and known issue. IDMT hides known system provided schema and that list is in in the the JAR file.

    Create a sample schema in your Oracle database and it will show up.