Topic
1 reply Latest Post - ‏2012-05-15T12:55:55Z by SystemAdmin
ramakrishnamanu
ramakrishnamanu
2 Posts
ACCEPTED ANSWER

Pinned topic DMT : not able to connect to ORACLE

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

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

Thanks

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

    Re: DMT : not able to connect to ORACLE

    ‏2012-05-15T12:55:55Z  in response to ramakrishnamanu
    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.