Migration tool not working with Oracle
The reverse engineer step fails in Oracle 8.1.7.4.
Fetch all views of the schema MOJOAPP.
SELECT v.*, c.STATUS as CHECK_ENABLED FROM ALL_VIEWS v, ALL_CONSTRAINTS c WHERE v.OWNER=? AND c.TABLE_NAME(+)=v.VIEW_NAME AND c.CONSTRAINT_TYPE(+)='V'ORDER BY v.OWNER, v.VIEW_NAME
The schema could not be reverse engineered (error: 0).
ORA-00942: table or view does not exist
Details:
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
com.mysql.grt.modules.ReverseEngineeringOracle.reverseEngineerProcedures(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringOracle.reverseEngineer(Unknown Source)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)
Subject
Written By
Posted
Migration tool not working with Oracle
May 04, 2005 11:48AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.