Re: Oracle Migration Failed
Posted by: ralf dobrick
Date: May 03, 2005 03:21AM

Hello,
I have the same problem.
I guess that i have the problem because i have a Oracle 8.0.5 version.
In the Migration Toolkit connection parameters there is a notice, that only Oracle 9i and 10g version are supported.
What version do you have?
Did you solve the problem meanwhile?
regards ralf

---MESSAGE LOG----------------------------------------------------------
Initializing JDBC driver.
Driver class oracle.jdbc.OracleDriver
Opening connection.
Connection jdbc:oracle:thin:histdb/histdb@za01sl03:1527:kpr
Build simple Oracle datatypes.
Call Oracle stored procedure ANALYZE_SCHEMA for HISTDB.
CALL DBMS_UTILITY.ANALYZE_SCHEMA(?, 'ESTIMATE', 50, 0, 'FOR TABLE')
The schema could not be reverse engineered (error: 0).
ORA-00900: invalid SQL statement

Details:
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1313)
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1232)
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:1353)
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1805)
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:320)
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:364)
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)

Options: ReplyQuote


Subject
Written By
Posted
April 25, 2005 11:57AM
Re: Oracle Migration Failed
May 03, 2005 03:21AM


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.